Skip to content

Registered aircraft · 20,687

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:90-06-03-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-06-03-R1') 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:90-06-03-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-06-03-R1')
  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:90-06-03-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-06-03-R1')
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.

N915DAb Prop Plane II LLC · Metairie, LABuilt 2017 · S/N 172S12071 N915DDWest Michigan Aviation Academy · Grand Rapids, MIBuilt 1999 · S/N 172S8149 N915LCardinal Flying Corp · San Jose, CABuilt 1976 · S/N 17267355 N915TAAurora Aircraft LLC · Waterford, MIBuilt 2006 · S/N 172S10358 N915WBBordelon Warren P · Breaux Bridge, LABuilt 1972 · S/N 17261221 N9160BS & J Investments LLC · Sardis, MSBuilt 1958 · S/N 36760 N9160HTodd Media Inc · Tuscaloosa, ALBuilt 1975 · S/N 17265984 N9161BLee Mark S · Grove, OKBuilt 1958 · S/N 36761 N9161HAir Athens LLC · Athens, GABuilt 1975 · S/N 17265985 N9161TMenagerie Enterprises Inc DBA · Denison, TXBuilt 2011 · S/N 172S11093 N9162BMedic Choppers LLC · Springdale, ARBuilt 1958 · S/N 36762 N9162HStratus Aviation LLC DBA · Vacaville, CABuilt 1975 · S/N 17265986 N9163BWright Donald E · Greensboro, NCBuilt 1958 · S/N 36763 N9166BWusterhausen Jerry L · Boynton Beach, FLBuilt 1958 · S/N 36766 N91673Martin Charles W · Twain Harte, CABuilt 1973 · S/N 17261506 N9167BAshley-Nye Johanna I · Graham, WABuilt 1958 · S/N 36767 N9168BAverett Joseph B · Denham Springs, LABuilt 1958 · S/N 36768 N916ATKdrd Holdings LLC · Texas City, TXBuilt 1982 · S/N 17275931 N916AVLopez Virgilio D · Brookshire, TXS/N 17272800 N916BAMaya Aircraft Holdings LLC · Lee, NHBuilt 2002 · S/N 172S9116 N916BQ9k Air LLC · Newark, DEBuilt 2021 · S/N 172S12756 N916ET9k Air LLC · Newark, DEBuilt 2021 · S/N 172S12759 N916FT9k Air LLC · Newark, DEBuilt 2021 · S/N 172S12758 N916GW9k Air LLC · Newark, DEBuilt 2021 · S/N 172S12760 N916HT9k Air LLC · Newark, DEBuilt 2021 · S/N 172S12761 N916KTPelican Flight Training LLC · San Carlos, CABuilt 2021 · S/N 172S12763 N916MABusch Brett · Stanford, MTBuilt 1999 · S/N 172S8265 N916MHHelmerich Jonathan D Jr · Tulsa, OKBuilt 1969 · S/N 17258177 N916NT9k Air LLC · Newark, DEBuilt 2021 · S/N 172S12762 N916PBM & G Aircraft Management LLC · Aurora, ORBuilt 2021 · S/N 172S12765 N916PYBragg Kris M · Embden, MEBuilt 1968 · S/N 17257159 N916QTElizabeth City State University · Elizabeth City, NCBuilt 2021 · S/N 172S12766 N916RR9k Air LLC · Newark, DEBuilt 2021 · S/N 172S12767 N916SEEiland James · Phenix City, ALBuilt 1977 · S/N 17269640 N916TAAtp Aircraft 4 LLC · Wilmington, DES/N 17281076 N916UT9k Air LLC · Newark, DEBuilt 2021 · S/N 172S12768 N9170BRegistration Pending · Shohola, PARegistration pendingBuilt 1958 · S/N 36770 N9171HSonday Terrance · Spring, TXBuilt 1975 · S/N 17265990 N9173BSuperhawk LLC · La Center, WABuilt 1958 · S/N 36773 N9173HSmitty 172 LLC · Rockford, MIBuilt 1975 · S/N 17265992 N91751Aviators Cooperative LLC · Colorado Springs, COBuilt 1973 · S/N 17261509 N9176HSky Walker Flight School LLC · Adrian, MIBuilt 1975 · S/N 17265993 N9177BBolan Preston A · Phoenix, AZBuilt 1958 · S/N 36777 N9177HLind Enterprises LLC · Manistee, MIBuilt 1976 · S/N 17265994 N91793Oexmann James Bennett · Lexington, KYS/N 17261514 N9179BHuntley Larry T · Midlothian, TXFirst renewal noticeBuilt 1958 · S/N 36779 N9179HMeteiver Lawrence J · Elkhart, INBuilt 1975 · S/N 17265995 N917CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8337 N917FAAlpha Aircraft International LLC · Lake Worth, FLBuilt 1980 · S/N 17274062 N917GKAmdel Holding LLC · Houston, TXBuilt 1978 · S/N 17271567

Back to AD 90-06-03 R1