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.

N5309JRegistered aircraftRegistration pending, pending cancellationS/N 17273759N5309VFlight Training Aircraft LLC · Wilmington, DEBuilt 2002 · S/N 172S9274N530AUWateractive43 LLC · Auburn, CABuilt 2002 · S/N 172S9225N530ERZima Aviation LLC · Huntington, CABuilt 2002 · S/N 172S9113N530MTAcron Aviation Academy Inc · Sanford, FLBuilt 2007 · S/N 172S10569N530NDAerosim Academy Inc · Sanford, FLBuilt 2008 · S/N 172S10829N530PSSpartan Education LLC · Tulsa, OKBuilt 2005 · S/N 172S9859N530SCFoxtrot Aviation LLC · Oregon City, ORBuilt 2025 · S/N 172S13353N530WBDmb Aircraft Inc · Wilmington, DEBuilt 1975 · S/N 17265399N53107Pea-Wayman Flight LLC · Daytona Beach, FLS/N 17274684N5310DD & S Aviation LLC · Spring, TXBuilt 1979 · S/N 17272508N53116Wnc Aviation LLC · Arden, NCBuilt 2002 · S/N 172S9283N5311HBas Part Sales LLC · Greeley, COBuilt 2002 · S/N 172S9278N5312HSkywarrior Flight Training Inc · Pensacola, FLBuilt 1975 · S/N 17265400N5312KDelta State University · Cleveland, MSBuilt 2003 · S/N 17281143N5312SGace Flying Club · Ronkonkoma, NYBuilt 2002 · S/N 172S9285N5312VBounds Justin M · Houston, TXBuilt 2003 · S/N 172S9287N53134Sundog Logistics LLC · Lenexa, KSBuilt 1981 · S/N 17274691N5313TDingman James B · Spencerville, INS/N 17251213N53143Delta State University · Cleveland, MSBuilt 2003 · S/N 17281145N53147Cloud Cappers Flying Club Inc · Salisbury, NCBuilt 1981 · S/N 17274693N5314E57d Flyers LLC · Shelby Township, MIBuilt 1978 · S/N 17271835N5314KLaporte Aviation Services Inc · La Porte, INBuilt 1980 · S/N 17274060N5314RDelta State University · Cleveland, MSBuilt 2003 · S/N 17281144N5314TWynot Aviation LLC · Riverton, WYBuilt 1964 · S/N 17251214N5315EEastern Cincinnati Aviation Inc · Batavia, OHS/N 172S9291N5315TLocal Flight Adventures LLC · Morgantown, WVBuilt 1964 · S/N 17251215N5316GBerg Philip L · Chatsworth, CAS/N 172S9294N5316RTraining Planes LLC · Tampa, FLBuilt 1979 · S/N 172RG0053N5316THavre Flying Club Inc · Havre, MTBuilt 1964 · S/N 17251216N53176Perfect Agreements Leasing Inc · Trabuco Canyon, CAS/N 172S9299N5317DMonroe City Aviators LLC · Palmyra, MOBuilt 1979 · S/N 17272513N5317HHottel Cessna LLC · Prescott, AZBuilt 1975 · S/N 17265401N5317KN5317k Corp Trustee · Wilmington, DEBuilt 1980 · S/N 17274061N53182Wardlaw James C · Albuquerque, NMBuilt 1981 · S/N 17274697N53187Salomon William · Woodstock, NYBuilt 1981 · S/N 17274699N5318EBishops Ltd · Virginia Beach, VABuilt 1978 · S/N 17271836N5318GBoard Of Trustees Of Southern Illinois University · Murphysboro, ILBuilt 2003 · S/N 17281155N5319DCoachron Investments LLC · Grosse Ile, MIBuilt 1979 · S/N 17272514N5319RSchuster Glen N · Sleepy Eye, MNBuilt 1965 · S/N 17252843N5319TWilliams Robert F · New Cumberland, WVBuilt 1964 · S/N 17251219N531EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2023 · S/N 172S13069N531LGMills Daniel L · Manchester, MIBuilt 1997 · S/N 17280056N531NDN531nd LLC · Sammamish, WABuilt 2011 · S/N 172S11101N531PCWaldorff Jimmy M Jr · Altha, FLBuilt 1981 · S/N 17274698N53201Dickinson James J · Renton, WAFirst renewal noticeBuilt 1981 · S/N 17274701N53205Southern Aircraft Consultancy Inc Trustee · Casper, WYS/N 172S9307N5320TSand Benjamin R · Alta, IABuilt 1964 · S/N 17251220N5321AJust Plane Stuff Inc · Jackson, MSBuilt 2003 · S/N 172S9308N5321TSleep Michael D · Olathe, KSBuilt 1965 · S/N 17251221
Back to AD 90-06-03 R1