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.

N7828DDyer Royal J · Melrose, NYBuilt 1957 · S/N 22-5474N7828NBurris Jamey E · Mt Juliet, TNBuilt 1969 · S/N 28-5281N7828VHam Henry P · Saint Louis, MOBuilt 1964 · S/N 450N7828WIliff Aircraft Repair And Service Co Inc · Tulsa, OKBuilt 1966 · S/N 28-3759N7828YVan Laak James E · Poquoson, VAS/N 30-903N78295Cofsky Gregory J · Sandwich, MABuilt 1968 · S/N 17257556N78299Jb Aircraft LLC · Anchorage, AKBuilt 1968 · S/N 17257558N7829GKilo Sierra Aviation LLC · Sammamish, WAS/N 17259529N7829HGardom Brandon D · Spirit Lake, IDBuilt 1946 · S/N 12-729N7829NRoth Colin E · Anchorage, AKBuilt 1969 · S/N 28-5282N7829VAirdad LLC · Houston, TXBuilt 1964 · S/N 451N7829WBormann Charles F · Mooresville, NCBuilt 1964 · S/N 28-1844N782AN782a Leasing LLC · Linden, MIBuilt 1961 · S/N TD-469N782CAChristman Matthew T · Markle, INBuilt 1966 · S/N 28-21849N782FMFmfa Inc · Wilmington, DEBuilt 1981 · S/N 17274667N782GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881464N782LAN782la LLC · Philadelphia, PABuilt 2025 · S/N 28020214N782LULiberty University School Of Aeronautics · Lynchburg, VABuilt 2014 · S/N 4496372N782MFWallace State Community College · Hanceville, ALBuilt 2023 · S/N 28020122N782NDFox Leasing Group LLC · Hollywood, FLBuilt 2016 · S/N 4496397N782POrear Jeffrey W · Peshtigo, WIBuilt 2006 · S/N 25171N782SHJtc Aviation LLC · Nashville, TNBuilt 2004 · S/N 3616N782SNKingdom Air Corps · Sutton, AKBuilt 1973 · S/N 17261341N782WPPhelps Kevin D · Hobe Sound, FLBuilt 2011 · S/N 71355N782WWDraco Flight School DBA · Chino, CABuilt 1997 · S/N 17280295N782YBeitler Richard J · Pittsburgh, PABuilt 1978 · S/N M-2004N78302Gardner Christopher · South Saint Paul, MNBuilt 1968 · S/N 17257559N78303Citizen Air LLC · Port Angeles, WABuilt 1968 · S/N 17257560N78305Woollen Claude D · Moore, SCBuilt 1968 · S/N 17257562N7830GSkildum&Company LLC · Grand Marais, MNBuilt 1970 · S/N 17259530N7830NGonzalez Braulio A · Bourbonnais, ILBuilt 1969 · S/N 28-5284N7830WWildhaber Andrew W · Coal Creek, COBuilt 1964 · S/N 28-1845N7830YGospel Ministries International Inc · Mc Donald, TNBuilt 1965 · S/N 30-906N78312Roemer Joanne · Kemah, TXS/N 17257565N7831NRadar Service Terminated LLC · New York, NYBuilt 1969 · S/N 28-5285N7832DCamp Barry G · Lafayette, LAS/N 22-5478N7832SSjd Aviation LLC · Nescopeck, PABuilt 1967 · S/N 7859N7832VBaker Benjamin D · Catasauqua, PAS/N 2935N7832WRankin Kevin J · Maryville, MOBuilt 1964 · S/N 28-1849N78330Wings Over Texas Holdings LLC · Denton, TXBuilt 1968 · S/N 17257567N78331Clifton Jack D · La Junta, COS/N 17257568N78332Albright John T · Decatur, ALBuilt 1968 · S/N 17257569N78335Marotte David J · Windham, NHBuilt 1968 · S/N 17257570N78338Mbh Aviation LLC · Tulalip, WABuilt 1968 · S/N 17257572N78339Hopfmann Alwin E · Rutland, MABuilt 1968 · S/N 17257573N7833GOrlandi Properties LLC · Blairstown, NJBuilt 1970 · S/N 17259533N7833NStrait Brian C · Joplin, MOBuilt 1969 · S/N 28-5287N7833WLukehart Steve D · Lincoln, NEBuilt 1964 · S/N 28-1850N78341Davis Glenn A · Fair Oaks, CABuilt 1968 · S/N 17257575N78349Raker Theodore B · Hahira, GABuilt 1968 · S/N 17257578
Back to AD 90-04-06 R1