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.

N407BWBridgewater State University · Bridgewater, MABuilt 2000 · S/N 17280937N407EBAb Prop Plane II LLC · Metairie, LABuilt 2014 · S/N 172S11438N407FRRich Carolyn A · Redondo Beach, CABuilt 1997 · S/N 17280234N407MD9k Air LLC · Newark, DEBuilt 2021 · S/N 172S12764N407SCAlpha Charlie Aviation LLC · Oregon City, ORBuilt 2020 · S/N 172S12588N4080FGoggans John L · Mansfield, MOBuilt 1958 · S/N 36980N4086FShelton Joseph G · Kingman, AZBuilt 1958 · S/N 36986N408EPAb Prop Plane II LLC · Metairie, LABuilt 2014 · S/N 172S11439N408ESRussell Robert Q · Genoa City, WIBuilt 1997 · S/N 17280226N408LBM & G Aircraft Management LLC · Englewood, COBuilt 2012 · S/N 172S11157N4090FFox Aero Club · Catawba, NCBuilt 1958 · S/N 36990N4094FSchupbach Robert D · Clearwater, FLS/N 36994N4096FGood John G · Weatherford, TXBuilt 1958 · S/N 36996N4097FWadsworth Tom R · Roswell, NMBuilt 1958 · S/N 36997N4097MN4097m LLC · Boynton Beach, FLBuilt 1998 · S/N 17280322N409CRChristiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11440N409ESN409es LLC · Stuart, FLBuilt 1997 · S/N 17280231N409LPSolberg Aviation Co Inc · Whitehouse Station, NJS/N 172S9409N40CKDcy Aviation Group LLC · Linton, INBuilt 1977 · S/N 17269264N40ERFlying Aces Aero Fleet Inc · Guyton, GABuilt 1977 · S/N 17269569N40LYAsh Gary W · Houston, TXBuilt 1978 · S/N 17270900N40MUOracle Aviation LLC · Omaha, NEBuilt 1974 · S/N 17264170N40RFGamma Flight LLC · Reno, NVBuilt 2007 · S/N 172S10473N40RGDovy Aviation LLC · Houston, TXBuilt 1974 · S/N 17263241N40SPSmith Terry G · Liberty Twp, OHBuilt 1980 · S/N 17274099N40TPDraco Flight School DBA · Chino, CABuilt 1981 · S/N 17274723N4101FHanson Kathleen A · Wasilla, AKS/N 46001N4102FAdams Samuel M · Anna, TXBuilt 1958 · S/N 46002N4104FMcmahon William F · Westville, INS/N 46004N4106LHackens Bryan Jay · New Underwood, SDBuilt 1966 · S/N 17254175N4107LRobitaille Charles · Stephenville, TXS/N 17254176N4108LCriss Mark · Eaton Rapids, MIBuilt 1966 · S/N 17254177N4109LMarrian Jason · Westtown, NYBuilt 1966 · S/N 17254178N410BSCorestrength LLC · San Francisco, CABuilt 2005 · S/N 172S9966N410CRAtp Aircraft 8 LLC · Wilmington, DEBuilt 2014 · S/N 172S11441N410FRRegistration Pending · Pottstown, PARegistration pendingBuilt 1982 · S/N 17275212N410LRWings Over Texas Holdings LLC · Denton, TXBuilt 1997 · S/N 17280257N410MTAcron Aviation Academy Inc · Sanford, FLBuilt 2007 · S/N 172S10426N4110LNeu Aviation LLC · Benton, LABuilt 1966 · S/N 17254179N4111FRoss Karen F · Marion, TXBuilt 1958 · S/N 46011N4112FWard Leigh C · Garden Valley, IDBuilt 1958 · S/N 46012N4114LLarson Lynn R · Casselton, NDBuilt 1966 · S/N 17254183N4115LPierce Michael W · Leitchfield, KYBuilt 1966 · S/N 17254184N4116LHubbard Matt · Phoenix, AZBuilt 1966 · S/N 17254185N4117LPatrick Milan Jr · Shinnston, WVBuilt 1966 · S/N 17254186N4118FMountain Air Spray Co Inc · Craig, COS/N 46018N4118LUan Venture Partners LLC · Odessa, FLBuilt 1966 · S/N 17254187N4119FPlymate Claude L · Tehachapi, CABuilt 1958 · S/N 46019N4119LSugar Aircraft LLC · Oak Harbor, WAS/N 17254188N411DKSwaz Aviation LLC · Mesa, AZS/N 17260703
Back to AD 90-06-03 R1