AD 90-04-06 R1

Registered aircraft · 68,377

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

N78785Peck John M · Melrose, MTBuilt 1968 · S/N 17257759N78787Largent Walter S · Fairbanks, AKS/N 12-3948N78789Hooper Dan B · Zanesville, OHBuilt 1968 · S/N 17257761N7878V7878 Victor Inc · Tampa, FLBuilt 1964 · S/N 2841N78797Allen Stephanie R · Mukilteo, WABuilt 1968 · S/N 17257767N78799Aerolanding LLC · Enterprise, ALS/N 17257768N7879GComposite Systems Inc · Lake Worth, FLBuilt 1970 · S/N 17259579N7879HLorence Joshua J · Soldotna, AKBuilt 1946 · S/N 12-782N7879VRowan James T Jr · Silver City, NMBuilt 1964 · S/N 471N7879WFlyhome One LLC · Chandler, AZBuilt 1964 · S/N 28-1903N787AAMkpeaches Properties LLC · Newark, DEBuilt 2016 · S/N 81826N787ATCentral Virginia Flyers Flying Club Inc · Glen Allen, VABuilt 1976 · S/N 17267881N787BKAmeri Aircraft Sales And Service LLC · Champaign, ILBuilt 2021 · S/N BCV 21006N787BRNaron Robert W · Poolville, TXBuilt 1965 · S/N 28-2091N787CJInternational Air Services Inc Trustee · Carson City, NVBuilt 2010 · S/N 2843679N787CPArnett Wallace · Sullivan, INBuilt 1968 · S/N 17257760N787DHHodge Stephen E · Tipp City, OHBuilt 2017 · S/N 91514N787DJDgj Tex LLC DBA · Cleburne, TXBuilt 1977 · S/N 28-7816014N787EBStith Michael P · Boiling Springs, SCS/N AA5-0819N787ECSky Safety Inc · San Antonio, TXBuilt 2005 · S/N 40.529N787EZKordel Kade France · Allen, TXBuilt 1985 · S/N 1217N787FBHot Wings Aviation LLC · Fishers, INBuilt 2025 · S/N 28020210N787FMMelillo Vince · Belvidere, ILBuilt 1978 · S/N 15281802N787GHHelbach George · Black River Falls, WIBuilt 2023 · S/N 3411N787HCloudboy LLC · Bellevue, WABuilt 1930 · S/N 6002N787LHLawyers Real Estate Services LLC · Roswell, NMBuilt 2018 · S/N 001N787MTHeppe Andrew S DBA · Turner, MTFirst renewal noticeBuilt 1966 · S/N 18-8425N787NDuenas Carlos · Hurricane, UTBuilt 2007 · S/N 2123N787PEPhoenix East Aviation LLC · Daytona Beach, FLBuilt 1972 · S/N 34-7350033N787RHRushing Christian W · Savannah, GABuilt 1978 · S/N 435-78N787RPSilver Fox Aircraft LLC · Queen Creek, AZBuilt 1985 · S/N 28-8690025N787SCSilverthorne Adam · Walnut Creek, CABuilt 1962 · S/N DH-324N787SDDornberger Eric A · Aurora, COBuilt 2016 · S/N 91472N787SGContainer Stop Inc · Paso Robles, CABuilt 1953 · S/N 18-2916N787SPSierra Tango Ventures LLC · Monte Sereno, CABuilt 2001 · S/N 172S8714N787STCitabria N787st LLC · Reno, NVS/N 486-2004N787TKennedy Thomas M · Long Beach, CABuilt 2015 · S/N 0248N787TBWoods Phillip A · Cimarron, KSBuilt 1996 · S/N 22127N787TFAir Fleet Holdings LLC · Missoula, MTBuilt 2022 · S/N 2881555N787TJTate John D · Roseville, CABuilt 2019 · S/N 60124N787TKIal Corp · Lewes, DES/N 2881144N787WAnequim LLC · Omaha, NEBuilt 2000 · S/N 1107N787WTSemper Supra Air LLC · Ashland City, TNBuilt 1978 · S/N 17271319N78804Whitt James M · Meadowview, VABuilt 1968 · S/N 17257772N78805Fugleberg Richard H · Mayville, NDBuilt 1968 · S/N 17257773N78808Ginter Michael J · Oakland, MDBuilt 1968 · S/N 17257774N7880GGhegan John · Wilmer, ALBuilt 1970 · S/N 17259580N7880KMattingley Kenneth R · Willow, AKBuilt 1953 · S/N 22-937N7880WSefinas Avir LLC · Brooklyn, NYBuilt 1964 · S/N 28-1904N78819Houdek Dennis E · Roseburg, ORBuilt 1947 · S/N 111593
Back to AD 90-04-06 R1