Skip to content

Registered aircraft · 22,413

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:87-08-08-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-08-08-R3') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:87-08-08-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-08-08-R3')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:87-08-08-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-08-08-R3')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N3791WCherokee Trail Aviation LLC · Tontitown, ARBuilt 1966 · S/N 32-717 N3792TBrowning Marvin Robert · Berthoud, COBuilt 1967 · S/N 28R-30105 N3792WFrazer Thomas · Warren, ARBuilt 1966 · S/N 32-719 N3793WBas Part Sales LLC · Greeley, COBuilt 1966 · S/N 32-720 N3794K10 Skies LLC · Rockport, TXBuilt 1967 · S/N 28-23731 N3795TCrossen Executive LLC · Missouri City, TXBuilt 1967 · S/N 28R-30108 N3795WWendt Aaron · Temecula, CABuilt 1966 · S/N 32-722 N3796MRoth Jacques A · San Rafael, CABuilt 1978 · S/N 28R-7803194 N3796TWhitmore Allen R · Crestview, FLBuilt 1967 · S/N 28R-30109 N3797TMarshall Patrick R · Trail, ORBuilt 1967 · S/N 28R-30110 N3797WCarter Thomas Shane · Pinetop, AZBuilt 1966 · S/N 32-725 N3798KCrosswind Aviation Of Oklahoma LLC · Stillwater, OKS/N 28-23733 N3799KVea Lynn B · Mokena, ILBuilt 1967 · S/N 28-23734 N3799TFly 99t LLC · Pompano Beach, FLBuilt 1967 · S/N 28R-30112 N379BLBlue Line Aviation LLC · Smithfield, NCBuilt 2024 · S/N 2881779 N379BTPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010083 N379HPLiquid Transport Inc · Camilla, GABuilt 2004 · S/N 3257353 N379LAM&K Commercial Diving LLC · Fair Haven, VTBuilt 1965 · S/N 28-2418 N379NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2023 · S/N 2881659 N37BTStucki Andre O · Deerfield Beach, FLBuilt 1981 · S/N 32R-8113083 N37DMWilliams Arzania S · Bolingbrook, ILBuilt 1968 · S/N 28-25245 N37GCKoumi Enterprises LLC · Houston, TXBuilt 2002 · S/N 3257273 N37KSNarwani Anil V · Orlando, FLBuilt 1977 · S/N 28R-7703257 N37MVMonreal Michael · North Barrington, ILBuilt 1969 · S/N 32-40657 N37REGiroux Aeronautical Company LLC · Fulton, NYBuilt 1976 · S/N 32R-7780114 N37WDRudy Schmitt · Brookshire, TXBuilt 1967 · S/N 28-4550 N3800WJdj Transport LLC · Wilmington, DEBuilt 1966 · S/N 32-40128 N3801TSeefeldt John V · Monticello, MNBuilt 1967 · S/N 28R-30115 N3801WSale Reported · Silver City, IASale reportedS/N 32-729 N3802RN3802r LLC · New Ringgold, PABuilt 1970 · S/N 28-5830 N3803WDelp Ryan K · Southbury, CTS/N 32-731 N3804KWebster Max S · Dalton, PABuilt 1967 · S/N 28-23736 N3804TMarello Thomas J · Westminster, MDBuilt 1967 · S/N 28R-30118 N3805TEyth Isaac S · Fe Warren Afb, WYBuilt 1969 · S/N 28R-30119 N3806TFacklair LLC · Granville, OHBuilt 1967 · S/N 28R-30120 N3806WEndeavor Associates Inc · Atlantis, FLS/N 3257346 N3807WFeller Gerald A · Long Beach, CAS/N 32-736 N3808MWings Of Clearfield Inc · Centre Hall, PABuilt 1978 · S/N 28-7816377 N3808RCatalano Joan E · Sequim, WABuilt 1970 · S/N 28-5834 N3808WDodson International Parts Inc · Rantoul, KSBuilt 1966 · S/N 32-737 N3809TMiller Jo Ann · Atlanta, GABuilt 1967 · S/N 28R-30124 N3809WFair Skies Aviation LLC · Cincinnati, OHBuilt 1966 · S/N 32-739 N380BTPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010084 N380CASky West Aviation Inc Trustee · Albuquerque, NMBuilt 1999 · S/N 3257080 N3810MSurgical Innovations Inc · Suwanee, GABuilt 1978 · S/N 28-7816378 N3810TN3810t LLC · Kalispell, MTS/N 28R-30125 N3811KHendrickson Raymond G · Severn, MDBuilt 1967 · S/N 28-23737 N3811MBanks Jerry A · Collierville, TNBuilt 1969 · S/N 28R-35200 N3811TDeleon Muniz Mario Antonio · Riverside, CABuilt 1967 · S/N 28R-30126 N3811WMartin Gerard A · Boston, KYBuilt 1966 · S/N 32-741

Back to AD 87-08-08 R3