OpenAirDocs.org
AD 90-06-03 R1

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
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.

N3891QRiley George L III · Washington, INBuilt 1971 · S/N 17259991N3891RN3891r LLC · Ogden, IAS/N 17255391N3892LHuettl Austin · Liberty Hill, TXBuilt 1965 · S/N 17254061N3892QKcn Aero Club Inc · Overland Park, KSS/N 17259992N3892SState Technical College Of Missouri · Linn, MOS/N 17251092N3893QSisung Ty J · Roxie, MSBuilt 1971 · S/N 17259993N3895LGoodyear Aviation Business Services LLC · Buckeye, AZBuilt 1965 · S/N 17254064N3895SPrins Kylee S · Eden, SDBuilt 1963 · S/N 17251095N3896LMcphillips Flying Service Inc · Beaver Island, MIBuilt 1965 · S/N 17254065N3896QNishna Valley Flying Club · Red Oak, IABuilt 1971 · S/N 17259996N3896RSabatka John M · Madison Lake, MNBuilt 1966 · S/N 17255396N3896SFishsaildiveeat LLC · North Miami Beach, FLBuilt 1963 · S/N 17251096N3897RPrice William B · Lamar, SCBuilt 1966 · S/N 17255397N3897SMartin Neil T · Peoria Heights, ILBuilt 1964 · S/N 17251097N3898QJaynes Grayson V Sr · Burnet, TXBuilt 1971 · S/N 17259998N3898ROverlord Aviation LLC · Melbourne, FLBuilt 1966 · S/N 17255398N3898SHangar 20 Flying Club LLC · Climax, MIS/N 17251098N3899QFlight Inc · Gastonia, NCBuilt 1971 · S/N 17259999N3899RLockett Joseph Jr · Philadelphia, PAS/N 17255399N389CLCanaan Land Church Inc · Autaugaville, ALBuilt 1972 · S/N 17260700N389CPCivil Air Patrol · Maxwell Afb, ALBuilt 2020 · S/N 172S12521N38CKHartsfield Amy G · Pace, FLS/N 17263959N38FRHenry Scott · Kingman, AZBuilt 1978 · S/N 17270698N38PAMarine Flyer LLC · Eddyville, KYBuilt 1977 · S/N 17270182N38PDRichmond Pilots Corp · Linden, NJBuilt 2000 · S/N 172S8381N38RAAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13272N38SBAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13261N3900FNolen Parker · Manson, WABuilt 1958 · S/N 36800N3900LShaw Flying Club LLC · Cleveland, MSS/N 17254069N3900SCrowe Tim · Winchester, KYBuilt 1964 · S/N 17251100N3901FCda Maine LLC · Winthrop, MEBuilt 1958 · S/N 36801N3901LSan Fernando Aviation LLC · Van Nuys, CAS/N 17254070N3901RMuth Joseph A · Richmond, KYS/N 17255401N3901SEggett Glade · Brigham City, UTBuilt 1963 · S/N 17251101N3902FMagaw David N · Sacramento, CABuilt 1958 · S/N 36802N3902RBotero Jorge · Alexandria, VAS/N 17255402N3902SGooding Flying Club · Gooding, IDBuilt 1963 · S/N 17251102N3903FSlattery Gordon C · Chippewa Falls, WIBuilt 1958 · S/N 36803N3903RDanielson Bradley K · Willmar, MNBuilt 1966 · S/N 17255403N3903SAt Aero LLC · Wilmington, DEBuilt 1963 · S/N 17251103N3904FPedersen Blake A · Clackamas, ORBuilt 1958 · S/N 36804N3904QKern Bruce A · Collinsville, OKBuilt 1971 · S/N 17260004N3904SLambert Aviation Service LLC · Washington, PABuilt 1963 · S/N 17251104N3905QH&H Cloudbase Aviation LLC · Carlsbad, CAS/N 17260005N3905RShea Michael P · Nashua, NHBuilt 1966 · S/N 17255405N3906RHorning Richard · Galion, OHS/N 17255406N3907FTaylor William Bc · Quincy, CABuilt 1958 · S/N 36807N3907L33 Global LLC · Potomac Falls, VABuilt 1965 · S/N 17254076N3907RNexgen Aviation LLC · Ennis, TXBuilt 1966 · S/N 17255407N3907SWilliamson Henry H · Conway, SCBuilt 1964 · S/N 17251107
Back to AD 90-06-03 R1