Skip to content

Registered aircraft · 54,015

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-20-03-R2') 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-20-03-R2') 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-20-03-R2')
    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-20-03-R2')
  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-20-03-R2')
  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-20-03-R2')
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.

N6978GSaia Mark · Oak Harbor, WAS/N 15072478 N6979AButcher William J · Salem, OHS/N 17229079 N6979BCenturion Bravo LLC · Houston, TXBuilt 1978 · S/N 21062863 N6979GWestall Ken L · Santa Maria, CABuilt 1970 · S/N 15072479 N6979HWhitaker Ian S · Fort Mohave, AZBuilt 1975 · S/N 17265678 N6979NArango Jorge · Mcallen, TXBuilt 1979 · S/N 21063188 N6979XScott Thomas A Jr · Lawrenceburg, TNBuilt 1960 · S/N 17247879 N697FLAeroflyin Corp · Pembroke Pines, FLS/N 17276100 N6980FEnvii Aviation LLC · Monroe, WAS/N 15063580 N6980GSamudio Lazaro III · Wildomar, CABuilt 1970 · S/N 15072480 N6980MPetumenos Timothy James · Anchorage, AKBuilt 1977 · S/N 21062005 N6980XMartin Timothy L · Cecilia, KYBuilt 1960 · S/N 17247880 N6981EShaneyfelt Dwight A · Fortuna, CAS/N 56481 N6981HAll2fly LLC · Atlanta, GABuilt 1975 · S/N 17265679 N6981SSalerno Gina · Cape Coral, FLBuilt 1967 · S/N 15067681 N6981XBoswell Steven P · Clear Spring, MDBuilt 1960 · S/N 17247881 N6982GBedford Cutter G · Bremerton, WAS/N 15072482 N6983EBurkhardt Charles P Jr · Norco, CABuilt 1960 · S/N 56483 N6983GGoemmel Steven J · Airway Heights, WABuilt 1971 · S/N 15072483 N6983HWaddell Pap LLC · Friendswood, TXBuilt 1975 · S/N 17265681 N6983XOptivol Corp · Miami, FLBuilt 1960 · S/N 17247883 N6984GCoffel Alexander · Meridian, IDS/N 15072484 N6984XFive Delta Sierra Inc · Pembroke Pines, FLBuilt 1960 · S/N 17247884 N6985AImwalle John N · Batavia, OHBuilt 1956 · S/N 29085 N6985EThomas Steven J · Wasilla, AKBuilt 1960 · S/N 56485 N6985GBustamante Wilton F · Whitsett, NCBuilt 1971 · S/N 15072485 N6985XNazario Juan A · Orlando, FLBuilt 1960 · S/N 17247885 N6986APoindexter Charles A Sr · West Point, MSBuilt 1956 · S/N 29086 N6986SKass Deborah J · Chandler, AZBuilt 1967 · S/N 15067686 N6986XMcallister Paul · Delafield, WIBuilt 1960 · S/N 17247886 N6987FGacesa Samuel M · Belton, TXBuilt 1966 · S/N 15063587 N6987SHubbard Broadcasting Inc · Saint Paul, MNBuilt 1967 · S/N 15067687 N6988ARegistered aircraftBuilt 1956 · S/N 29088 N6988EPeterson Andrew B · Louisville, KYS/N 56488 N6988FPaulson Allerton · Anoka, MNBuilt 1966 · S/N 15063588 N6988XPaul Aviation LLC · Wasco, CAS/N 17247888 N6989MRp Wellons Aircraft LLC · Dunn, NCBuilt 1975 · S/N 18263910 N6990EGray Jade · Odessa, TXS/N 56490 N6990FWohlers Paul A · Calimesa, CABuilt 1966 · S/N 15063590 N6990YV Speed Aviation LLC · Reno, NVBuilt 1964 · S/N 21058490 N6991EHiggins Frank E · Rio, WIBuilt 1960 · S/N 56491 N6991FMeyer George D · Paradise, CAS/N 15063591 N6991GMid South Aircraft Sales Inc · Glencoe, ALBuilt 1971 · S/N 15072491 N6991HRhinelander Flying Service Inc · Palmetto, FLBuilt 1975 · S/N 17265683 N6992EMikkelsen John P · Sebastopol, CABuilt 1960 · S/N 56492 N6992FJenkins Seth A · Charlotte, NCBuilt 1966 · S/N 15063592 N6992GMosch Edward C · Indialantic, FLBuilt 1971 · S/N 15072492 N6992XBurleson James R · Snyder, TXBuilt 1960 · S/N 17247892 N6993AHurta Jennifer · Cypress, TXBuilt 1956 · S/N 29093 N6993ENewberry Wilma L · West Paducah, KYBuilt 1960 · S/N 56493

Back to AD 87-20-03 R2