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.

N44AYPartin Kathy L · Nacogdoches, TXS/N 28R-7535012N44BAKnop Horacio M · Miami, FLBuilt 1979 · S/N 38-79A0442N44BKBirum Kevin M · Kingston, WABuilt 2001 · S/N 5573N44BLBoehr Greg J · Mc Cool Junction, NES/N 17256854N44BWMariani Aviation Services LLC · Vero Beach, FLBuilt 1987 · S/N 219N44CHRunyon Aviation LLC · Fort Worth, TXBuilt 1946 · S/N 1454N44CUAirstar Aviation LLC · Manawa, WIBuilt 1976 · S/N 17268037N44CZHeer James A · Lutz, FLBuilt 1988 · S/N 1N44DMGorge Winds Aviation Inc · Fairview, ORBuilt 1973 · S/N 17261488N44EBray Nick R Trustee · China Spring, TXBuilt 1947 · S/N 12-2575N44EWPlane Fun Inc Tr Trustee · Snellville, GABuilt 1978 · S/N 1-0058N44FDHildreth David M · Kennesaw, GABuilt 1956 · S/N 23-500N44FMHolmgren David P · Kamas, UTBuilt 1995 · S/N LB-1N44FSJinsky Ronald G · Beloit, WIBuilt 1975 · S/N 717N44GDCarver Michael A · Ocala, FLBuilt 2009 · S/N 004N44HKBradt Joseph J · Inver Grove, MNBuilt 1997 · S/N 79597N44HUFritsche James G · Greenleaf, WIBuilt 1997 · S/N 1353N44HYCochran Thomas S · Fort Collins, COBuilt 2001 · S/N 2145N44JLBushcat Goldie LLC · Oro Valley, AZBuilt 2015 · S/N 72279N44JRRodgers Jerry T · Bishop, CABuilt 1997 · S/N 24545N44KDSale Reported · Crystal, MNSale reported, canceledBuilt 1972 · S/N 28R-7235106N44KLStell Brandon A · Mechanicsville, VAS/N 803N44KPHargrave Margarite D · Seattle, WABuilt 1978 · S/N 172-70904N44LFFry Larry D · Ocala, FLBuilt 2021 · S/N 70947N44LKCessna Skyhawk LLC · Parker, COFirst renewal noticeBuilt 1979 · S/N 17273400N44LRRouse Peter L · Parkville, MOBuilt 1996 · S/N 1N44LTLonderville Ross G · Stanwood, WABuilt 1984 · S/N 348N44LYPuls Kurt V · Valparaiso, INS/N 82777N44MHDrewry James D · Dayton, TXBuilt 1979 · S/N 13308N44MNBaker Larry M · Greenville, TXBuilt 1977 · S/N 212236N44PDBurril Leslie A · Cleveland, GAS/N 1N44PFVaayu Aviation LLC · Newark, CABuilt 1970 · S/N 28-26800N44PGSimon Jevon D · Buckley, WABuilt 1999 · S/N 2522-001N44PHHatch Fletcher A III · Vero Beach, FLBuilt 2002 · S/N 0002N44PJSchaufenbuel Todd W · Imperial, NEBuilt 1992 · S/N 1209N44PMPhipps Johnny · Salem, ORBuilt 1952 · S/N 22-726N44PPKnr Inc · Evanston, WYBuilt 1955 · S/N 22-2576N44PWWeber Peter III Trustee · Loudon, TNBuilt 1979 · S/N 28-8090147N44PXMartinez Victor J · Sylmar, CAS/N JNC-1N44PYSegler Angela U · Marco Island, FLBuilt 2000 · S/N 172S8543N44QGraf Erwin · Clayton, NCBuilt 1974 · S/N 446N44RRRichardson Robert L · Rch Palos Vrd, CABuilt 1985 · S/N R-1N44RTWinkelman Dan · Bethel, AKBuilt 1971 · S/N 18-8927N44SDKandle Douglas A · Boise, IDBuilt 2015 · S/N TCQ1007068N44SJHarpreet Sandhu · Livermore, CABuilt 1977 · S/N 0752N44SMHinds Community College · Raymond, MSBuilt 1976 · S/N 28R-7635076N44STTakvorian Sevag · West New York, NJBuilt 1979 · S/N 17271609N44TCKinzie Hon K · Anchorage, AKBuilt 2002 · S/N 9941CCN44TDChristian Joe L · Naylor, GABuilt 1973 · S/N 1000N44VTNelson William R · Caldwell, IDBuilt 1994 · S/N 20121
Back to AD 90-04-06 R1