OpenAirDocs.org
AD 90-06-03 R1

Registered aircraft · 20,687

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.

N777CASwamp Skies LLC · North Miami, FLS/N 17268259N777DUSc Infinities LLC · Dover, DEBuilt 1971 · S/N 17259854N777HEUsoarflorida LLC · Fort Myers, FLS/N 172S8120N777UMMahlik Michael A · Casco, WIS/N 17275405N7780GAero Quest LLC DBA · Olive Branch, MSBuilt 1970 · S/N 17259480N7780XRegistration Pending · Meridian, IDRegistration pendingS/N 17248280N7781GKelley Aircraft LLC · Weyers Cave, VABuilt 1970 · S/N 17259481N7781TChouinard Shawn A · Collinsville, OKBuilt 1960 · S/N 47381N7781UKerslake Alex J · Ellensburg, WABuilt 1964 · S/N 17251781N7781XPeraro Thomas A · Brighton, COS/N 17248281N7782THicks Thomas H · Conway, ARS/N 47382N7782XBoucher Roberta Ann · Fredericksburg, VABuilt 1961 · S/N 17248282N7783UEppich Glen M · Kingman, AZBuilt 1964 · S/N 17251783N7784GAll2fly LLC · Atlanta, GABuilt 1970 · S/N 17259484N7784TJustonemore LLC · Fayetteville, ARBuilt 1960 · S/N 47384N7785UTwo Farmers LLC · Dumas, ARS/N 17251785N7786GRcm Aviation LLC · North Clarendon, VTFirst renewal noticeBuilt 1970 · S/N 17259486N7786UWooton Donald Wayne · Houston, TXFirst renewal noticeBuilt 1964 · S/N 17251786N7787USageser Scott · Carmi, ILS/N 17251787N7788UHoffmeyer Scott D · Carson City, NVBuilt 1964 · S/N 17251788N7788XBowling John D · Bryan, TXBuilt 1961 · S/N 17248288N7789UViolette David A · Medway, MEBuilt 1964 · S/N 17251789N778AASolo Aircraft Rental LLC · Farmingdale, NYS/N 172S9933N778SATextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13582N7790TAviation Trade Inc · Castroville, TXBuilt 1960 · S/N 47390N7790UPlane Fun Inc Tr Trustee · Snellville, GABuilt 1964 · S/N 17251790N7791H2 Aviation LLC · Middlebury, INBuilt 1979 · S/N 17272464N7791TVintage Aero Aviation LLC · Baldwin Park, CABuilt 1960 · S/N 47391N7791UHall Richard C Jr · Benton, KYFirst renewal noticeBuilt 1964 · S/N 17251791N7791XCarson Roy K · Prescott Valley, AZBuilt 1961 · S/N 17248291N7792TFrench Rodney A · Warsaw, INBuilt 1960 · S/N 47392N7792UOso Air LLC · Missoula, MTS/N 17251792N7792XNorthern Light Aviation LLC · North Waterboro, MEBuilt 1961 · S/N 17248292N7794XQuantum Edge Aviation Co · Boulder, COBuilt 1961 · S/N 17248294N7795TJim Air Inc · Wilmington, DEBuilt 1960 · S/N 47395N7795XMcclure Kyle · Elbert, COBuilt 1961 · S/N 17248295N7796XParnello Nick · Rockford, ILBuilt 1961 · S/N 17248296N7797TDanforth Lawrence P · Flushing, MIBuilt 1960 · S/N 47397N7798TCessna Aces LLC · Metairie, LABuilt 1960 · S/N 47398N7798USmythe Carl D · Tulsa, OKBuilt 1964 · S/N 17251798N779PTMacon Air LLC · Franklin, NCBuilt 1976 · S/N 17266667N779SATextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13583N77DHBramon Bruce M · Sunrise Beach, MOBuilt 1968 · S/N 17257127N77ERFrech Betty J Trustee · Columbia, MOBuilt 1977 · S/N 17269518N77FWBrooks Dylan · Anchorage, AKS/N 47409N77JFWilliams Mike C · Sonora, TXBuilt 1963 · S/N 17250383N77KBBears Tooth Resources LLC · Red Lodge, MTBuilt 1957 · S/N 36214N77LARaintree Aviation LLC · Mesa, AZBuilt 2017 · S/N 172S12030N77LUGerman Farms Inc · Fullerton, NDBuilt 2003 · S/N 17281154N7800GSale Reported · Roseville, MNSale reported, pending cancellationBuilt 1970 · S/N 17259500
Back to AD 90-06-03 R1