OpenAirDocs.org
AD 90-06-03 R1

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

N9754FFirst Eclipse Ltd · Richmond, VABuilt 1997 · S/N 17280037N9755DSkyline Solutions Inc · Deland, FLBuilt 1984 · S/N 17276227N9758BSherwood Aviation LLC · Lewes, DES/N 172RG1015N975BWWeidendorf Investments LLC · Hinckley, MNS/N 17270718N975TAMitchell David G · Cadiz, OHBuilt 2002 · S/N 172S9257N975THAnson Air LLC · Sugar Land, TXBuilt 2023 · S/N 172S12975N9764FFixed Wing Holding Co Inc · Pembroke Pines, FLBuilt 1997 · S/N 17280042N97650Updraft LLC · Kissimmee, FLS/N 17276218N97662Northwest Alabama Holdings LLC · Spruce Pine, ALBuilt 1984 · S/N 17276219N97674Oc Flight Lessons LLC · Costa Mesa, CABuilt 1984 · S/N 17276220N9767FMid Island Air Service Inc · Ronkonkoma, NYBuilt 1997 · S/N 17280066N97681Buiqui Aerospace Corp · Kissimmee, FLBuilt 1984 · S/N 17276221N97702Smith Jeffrey W · Yakima, WABuilt 1984 · S/N 17276222N97705Angel Aviation Inc · Peoria, AZBuilt 1984 · S/N 17276223N9770BCastle Michael Bernard · Raleigh, NCS/N 172RG1024N9773BChagres Flight Training LLC · Albuquerque, NMBuilt 1981 · S/N 172RG1027N97749Beck Shylan · Blanding, UTBuilt 1984 · S/N 17276225N9774BWagner Michael D · Winter, WIBuilt 1981 · S/N 172RG1028N9774WAmerican Patrols Inc · Midland, TXBuilt 1974 · S/N 17264500N97755Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1984 · S/N 17276226N9775BAequalis Photography Corp · Tacoma, WAFirst renewal noticeBuilt 1981 · S/N 172RG1029N97766Wiggins Air Patrol LLC · Wichita, KSBuilt 1984 · S/N 17276228N97779Kool Wings Leasing LLC · Indianapolis, INBuilt 1984 · S/N 17276230N97789Delta State University · Cleveland, MSBuilt 1984 · S/N 17276231N9779B79b Aviation LLC · Wilmington, DEBuilt 1981 · S/N 172RG1031N9779THill Kevin D · Port Lavaca, TXBuilt 1960 · S/N 47579N9779VCoombs Eric S · Louisburg, NCBuilt 1974 · S/N 17264501N977DWJulien Kathleen Y · Gig Harbor, WAS/N 46262N977KJFalcon Aviation Inc · Southfield, MIS/N 17261987N977SQFrech Egon Trustee · Lexington Park, MDBuilt 1979 · S/N 17272303N977THHeavy Metal Air LLC · Farmingdale, NYBuilt 2023 · S/N 172S12977N9780TGilbert Tanner A · Midland, TXS/N 47580N97811Angel Aviation Inc · Peoria, AZBuilt 1984 · S/N 17276232N9781TPacheco James S · West Ossipee, NHBuilt 1960 · S/N 47581N9782TFascenda Matthew Roman · Mint Hill, NCBuilt 1960 · S/N 47582N9782VOn Glideslope LLC · Middletown, DEFirst renewal noticeBuilt 1974 · S/N 17264502N9783PKent State University · Stow, OHBuilt 1984 · S/N 17276234N9784BRecycleworx LLC · Sun City, AZBuilt 1981 · S/N 172RG1034N9785BWebber Thomas W · Placerville, CABuilt 1981 · S/N 172RG1035N9786BTri State Airmotive LLC · Berryville, ARS/N 172RG1036N9786LPerun Av LLC · Cliffside Park, NJBuilt 1986 · S/N 17276612N9786THire Smart Folks LLC · Austell, GABuilt 1960 · S/N 47586N97873Kent State University · Stow, OHBuilt 1984 · S/N 17276236N9787BRiemer Thomas H · Winchester, VABuilt 1981 · S/N 172RG1037N9787TMapes Peter B · Oscoda, MIBuilt 1960 · S/N 47587N97883Rick Aviation Inc · Newport News, VABuilt 1984 · S/N 17276237N978APAviation Leasing Company LLC · Ooltewah, TNBuilt 2008 · S/N 172S10710N978CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1997 · S/N 17280209N978FASky Training LLC · West Milford, NJBuilt 2002 · S/N 172S9078N978SAMarine Tech One LLC · Dover, DEBuilt 2002 · S/N 172S9178
Back to AD 90-06-03 R1