Registered aircraft · 20,683

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.

N5434RFlorida Keys Flight Academy LLC · Marathon, FLBuilt 1965 · S/N 17252982 N54355Elizabeth City State University · Elizabeth City, NCBuilt 1981 · S/N 17274960 N54357Rick Aviation Inc · Newport News, VAS/N 17274962 N5435EWings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 17271863 N5435HWindham Brealon A · Kingsville, TXBuilt 1975 · S/N 17265433 N5435J22december LLC · Bartlett, ILS/N 17273793 N54360A S Flight Academy LLC · Lantana, FLBuilt 1981 · S/N 17274963 N5436EKitsap Aviation Squadron Inc · Southworth, WAS/N 17271864 N5436HTrue Course Air LLC · Rich Hill, MOBuilt 1975 · S/N 17265434 N5436TStrachn Adam · Lenoir City, TNBuilt 1964 · S/N 17251336 N54371Clare Air Services LLC · Saint Johns, MIS/N 17274966 N5437HBuena Vista Flying Club Inc · Richland Center, WIBuilt 1975 · S/N 17265435 N5437JMiloud Chadd K · Fort Worth, TXBuilt 1980 · S/N 17273794 N5437RSchafer Brian L · Carleton, MIBuilt 1974 · S/N 17263541 N54381Paradise South Ventures LLC · Marco Island, FLBuilt 1981 · S/N 17274968 N5438TFritz James A · Pierce, NEBuilt 1964 · S/N 17251338 N5439HMeyer Aviation Group LLC · Grand Island, NEBuilt 1975 · S/N 17265437 N5439KEastern Kentucky University · Richmond, KYBuilt 1980 · S/N 17274110 N5439RIndian Hills Community College · Ottumwa, IABuilt 1965 · S/N 17252989 N5439TSlone James E · Grundy, VAS/N 17251339 N543DFRichardson Daniel D · Caldwell, IDS/N 17251342 N543EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2025 · S/N 172S13314 N543NDN543nd LLC · Manassas, VABuilt 2010 · S/N 172S10985 N543THRidgeline Assets LLC · Wilmington, DEBuilt 2019 · S/N 172S12255 N5440EK & A Aviation Inc · Barnegat, NJBuilt 1978 · S/N 17271868 N5440KTwenty Two Juliet LLC · Tyler, TXBuilt 1980 · S/N 17274111 N5440TIsland Lady LLC · Iowa Falls, IAS/N 17251340 N54413Belcher Phillip B · Claremore, OKBuilt 1981 · S/N 17274970 N5441HKlein Darrell J · Deland, FLBuilt 1975 · S/N 17265439 N5441RGraham Norman J · West Ossipee, NHBuilt 1965 · S/N 17252991 N5441TCape Steven A · Columbia, KYS/N 17251341 N5442EUnterseher Pat L · Kearney, NEBuilt 1957 · S/N 36330 N5442HJones Gareth B · Goldsboro, NCBuilt 1975 · S/N 17265440 N5442RBarnes Terry A · Austin, TXBuilt 1965 · S/N 17252993 N5443VTurk Aviation LLC · O Fallon, ILBuilt 1980 · S/N 172RG0533 N54448Jupiter Flight Service And Investing LLC · Lithonia, GABuilt 1981 · S/N 17274974 N5444HIowa Lakes Community College · Estherville, IABuilt 1975 · S/N 17265442 N5444JHm Aviation LLC · Cape Fair, MOBuilt 1980 · S/N 17273798 N5444RAlpha Romeo Aviation LLC · Phoenix, AZBuilt 1965 · S/N 17252995 N5444TTappon Wayne A · Ladysmith, WIS/N 17251344 N54452Epling Kenny B · Mechanicsville, VABuilt 1981 · S/N 17274977 N5445RWimpy Gregory S · Griffin, GABuilt 1965 · S/N 17252997 N5445TSchallip Robert G III · White Lake, MIBuilt 1964 · S/N 17251345 N5446DJ And D Petroleum Co · Tallahassee, FLS/N 17272571 N5446HBlizzard William F Jr · Barboursville, WVBuilt 1975 · S/N 17265444 N54477Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1981 · S/N 17274983 N5447KFly For Fun LLC · Frederick, MDBuilt 1980 · S/N 17274114 N5447RToth Roger J · Willoughby, OHFirst renewal noticeBuilt 1965 · S/N 17252999 N5448RBuby Lloyd F · Mannington, WVBuilt 1965 · S/N 17253001 N5448TRegistration Pending · Las Vegas, NVRegistration pendingBuilt 1964 · S/N 17251348

Back to AD 90-06-03 R1