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.

N708JJacobsen Samuel J · Incline Village, NVBuilt 2003 · S/N 81429N708JAYale Companies LLC · Fishers, INBuilt 2026 · S/N 28020263N708LAN708la LLC · Philadelphia, PABuilt 2025 · S/N 28020220N708LSSchneider Larry E Trustee · Glendale, AZBuilt 2008 · S/N 70403N708TSamples Kurtis K · Dallas, TXS/N TTN-77N708TEAileron Aviation Inc · Cookeville, TNBuilt 1978 · S/N 17270934N708TFAverett University · Danville, VABuilt 2019 · S/N 2881238N708XEnsley Michael P · Colfax, WABuilt 2007 · S/N 70545N708YAltenbaumer Max Allen · Texarkana, TXBuilt 1958 · S/N TD-39N7090KUlibarri Christopher G · Abilene, TXBuilt 1950 · S/N 20-198N7090RMekolichick Jerry D · Whitehall, PABuilt 1966 · S/N 28-21793N7090WShipman Donald C · Interlochen, MIBuilt 1962 · S/N 28-877N7090YTucker Brandon · Rockledge, FLBuilt 1973 · S/N 28-7305058N7091GSkylark Flight Training LLC · Wilmington, DEBuilt 1969 · S/N 17258791N7091VFreimund Chandler R · Big Horn, WYBuilt 1976 · S/N 20-1217N7092FBerger Jeremy L · Noble, ILBuilt 1976 · S/N 28-7715194N7092GAmick Thomas C · Newberry, SCBuilt 1969 · S/N 17258792N7092RCosey William Vester Franklin · Inverness, FLBuilt 1966 · S/N 28-21796N7092VTextor William E · Springfield, MOBuilt 1976 · S/N 20-1218N7093BBackcountry Aviation LLC · Berthoud, COFirst renewal noticeBuilt 1957 · S/N 18-5176N7093FPockrus Pat B · Mineral Wells, TXBuilt 1966 · S/N 15063693N7093GAero Performance LLC · Scooba, MSBuilt 1969 · S/N 17258793N7093KMoyers Tommy E · Portland, ARBuilt 1950 · S/N 20-199N7093RKearns Joseph E · Worthington, OHBuilt 1966 · S/N 28-21797N7093YMoore James S Trustee · Gray Court, SCBuilt 1963 · S/N 30-108N7094DPotter Kent · Laurel, MTBuilt 1957 · S/N 18-5584N7094GJohnson And Assoc · Davenport, IABuilt 1969 · S/N 17258794N7094QRegistered aircraftBuilt 1972 · S/N 17260394N7094RWilson Flyers LLC · Rocky Mount, NCBuilt 1966 · S/N 28-21798N7094VMason Gary W · Rockledge, FLBuilt 1976 · S/N 22-1422N7095GHunter John Bockett · Riverton, NJBuilt 1969 · S/N 17258795N7095QWong Henry L III · Lake Forest, CABuilt 1972 · S/N 17260395N7095RStevens Aircraft LLC · Morehead, KYBuilt 1966 · S/N 28-21799N7095WByers Brady L · Newberg, ORBuilt 1962 · S/N 28-882N7096RHumphrey Richard K Jr · Abilene, TXBuilt 1966 · S/N 28-21800N7096WN7096w LLC · Sherman Oaks, CABuilt 1962 · S/N 28-883N7097GMurdy David C · Round Rock, TXBuilt 1969 · S/N 17258797N7097RFields Michael L · Rockwood, TNBuilt 1966 · S/N 28-21802N7097WGlidepath Consulting LLC · Yuma, AZBuilt 1962 · S/N 28-884N7098KHensley Roger A · Rosamond, CAS/N 20-206N7098WFarabee Mechanical Inc · Hickman, NEFirst renewal noticeBuilt 1962 · S/N 28-885N7099CAnderson Richard Alan · Brainerd, MNBuilt 1975 · S/N 28-7615042N7099GHunt Howard E · Martinsville, ILBuilt 1969 · S/N 17258799N7099KLach Richard · Weldon, CAS/N 20-207N7099QVenaleck John T · Painesville, OHBuilt 1972 · S/N 17260399N7099YSparks Richard A · Wasilla, AKS/N 18-8135N709ABLohmann David P · Edwards, COBuilt 1974 · S/N BH120/331N709BTAverett University · Danville, VABuilt 2017 · S/N 2843920N709BWWolf Robert B · Boise, IDBuilt 1999 · S/N 25111N709CAChristiansen Aviation LLC · Wilmington, DEBuilt 2024 · S/N 2881729
Back to AD 90-04-06 R1