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.

N56501Hair Heather D Trustee · Bonner, MTBuilt 1983 · S/N 8022CN56506Nassour Aviation Inc · Ellisville, MSBuilt 1973 · S/N 28-73-25641N5650QOrtland Richard James · Franklin, MIS/N 681N5650SOliver Jonathan · Maryville, TNBuilt 1966 · S/N MA-68N5650USkyways Group LLC · Greensboro, NCBuilt 1969 · S/N 28-26446N5651BRoland David K · Lockhart, TXBuilt 1981 · S/N 8018CN5651HCramer Nicholas R · Lexington, OHS/N 16-262N5651QKingdom Air LLC · Diamondhead, MSBuilt 1965 · S/N 3024N5652Leary Brian J · Fredricksburg, PABuilt 1972 · S/N 595N56521Hawkes Tyler · Rexburg, IDBuilt 1973 · S/N 28-73-25647N56524Registration Pending · West Palm Beach, FLRegistration pendingS/N 28-73-25650N56525Sadi Susan Salimi · Arlington, TXS/N 28-7325651N56528Delzer James K · Sanger, TXBuilt 1984 · S/N 8023CN56529Jilek Peter A · River Falls, WIBuilt 1973 · S/N 34-7350346N5652ECgumps LLC · Antioch, TNBuilt 1978 · S/N 17271912N5652LSkelton Thomas Nichols Jr · Jackson, MSBuilt 1977 · S/N MC-533N5652WDamazo Kimber P · Portland, ORBuilt 1984 · S/N 8033CN5652ZClifford Karl N · Lubbock, TXBuilt 1962 · S/N 22-9475N56536Hurlbut Gary A · Seattle, WABuilt 1973 · S/N 28-7325653N5653LUlpiano Amy · Carolina, PRBuilt 1969 · S/N AA1-0053N5653PBeasley Charles R · Lumberton, NCBuilt 1959 · S/N 24-724N5653RSchoenau Michael · Tulare, CAS/N 11001CN5653UMcclelland Robert C · La Veta, COBuilt 1969 · S/N 28-26449N5653WCrump William J · Williamstown, NJFirst renewal noticeBuilt 1962 · S/N 28-840N56545Sauder Richard J · Evergreen, COBuilt 1984 · S/N 8040CN56547Schroeder Gordon D · New Braunfels, TXBuilt 1984 · S/N 8055CN5654BStol-Air LLC · Salem, ORFirst renewal noticeBuilt 1984 · S/N 8035CN5654DMiller Arlyn E · Boise, IDBuilt 1984 · S/N 8038CN5654PLiebrecht Dennis L DBA · Ocala, FLBuilt 1959 · S/N 24-725N5654SWilcox Ryan · Brookland, ARBuilt 1966 · S/N MA-80N5654URoss Michael M Trustee · Anchorage, AKBuilt 1984 · S/N 8043CN5654VHodges Tandi R · The Woodlands, TXBuilt 1977 · S/N 28-7716190N5654WHaymes Will · Knoxville, TNBuilt 1962 · S/N 28-815N5655Phillips Mark E · Williamsville, ILS/N 28-3720N56550Holmes Peter L · Erieville, NYBuilt 1984 · S/N 8056CN56557Mannering Robert D · Warrensburg, MOS/N 11002CN56558Onlyfly LLC · Deltona, FLS/N 28-7425004N56559Waggoner Gregory · Woodward, OKBuilt 1973 · S/N 28-7405017N5655HRansdell Elise A · Springfield, ILBuilt 1947 · S/N 16-266N5655QJamil Mohammad Mahbub · Stockton, CABuilt 1965 · S/N 3026N5655RKavalieros James A · Bridgewater, NJBuilt 1984 · S/N 8049CN5655ZTroth Gary D · Mound City, KSBuilt 1962 · S/N 22-9478N5656EN2893e LLC · Reno, NVBuilt 1978 · S/N 17271913N5656HCaldwell Joel · Galveston, TXS/N 16-267N5656PTaylor National Transportation LLC · Palatine, ILBuilt 1959 · S/N 24-727N5656WBennett Steven D · Durham, NCS/N 28-821N5656YD & D Airpark LLC · Anchorage, AKBuilt 1965 · S/N 18-8290N5657Woods Donald E · Great Falls, MTBuilt 1974 · S/N 4426N56573Knuth Matthew · Waupaca, WIBuilt 1973 · S/N 28-7405019N56578Somerset Air Service Inc · Bedminster, NJBuilt 1973 · S/N 28-7325661
Back to AD 90-04-06 R1