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.

N5017MNo Limits Aviation Inc · Lincoln, MTS/N ME-54N5017RR&R Leasing LLC · Fargo, NDBuilt 1974 · S/N 17263258N5018PTseng Leon Y · Tucson, AZBuilt 1958 · S/N 24-21N5018UFlight Gate LLC · Wilton, CABuilt 1993 · S/N 2279N5018ZDowning John D · Marion, MIBuilt 1961 · S/N 22-8633N50193Folsom Gary A · Marianna, FLBuilt 1974 · S/N 17264196N5019SGordon Patricia I · Desoto, TXS/N 28R-35751N5019WShipley Kelly R · Astoria, ORBuilt 1961 · S/N 28-20N5019ZCsapos Garry A · Ovid, MIS/N 22-8634N501AHOlah Gregory J · High Point, NCBuilt 1966 · S/N MB-80N501BAFalcon Air LLC · Orlando, FLS/N 326-72N501BSBlue Skies Enterprises Of Texas · Richmond, TXBuilt 2005 · S/N 1005-2005N501CHill Chad M · Makinen, MNBuilt 1947 · S/N 108-3501N501DWParmar Bluffs LLC · Parker, SDBuilt 1996 · S/N 939-76N501EHDupont Pierre B · Menominee, MIBuilt 1966 · S/N 5N501ELJourneys Aviation Inc · Boulder, COBuilt 2009 · S/N 1404-2009N501ERVista Air Inc · Pacoima, CABuilt 2001 · S/N 172S8947N501GLSharp Aviation LLC · Pauls Valley, OKBuilt 1973 · S/N 0501N501HLAarow Aircraft Leasing LLC · Mcminnville, ORBuilt 1995 · S/N 2500N501JAAlongi John J · Downers Grove, ILBuilt 1990 · S/N 501-RN501MAContinental Aerospace Technologies Inc · Mobile, ALBuilt 2021 · S/N 2881479N501MERoby Gregory Carl · Owensboro, KYS/N 11N501MPManzoor Khan · Stockton, CABuilt 1978 · S/N 17270318N501PLDick Timothy R · Fox Lake, ILBuilt 2001 · S/N 5272N501PWFlywerx LLC · Anchor Point, AKS/N 12-1445N501RDBackcountry Endeavours LLC · Dassel, MNBuilt 1992 · S/N 2164N501REIndependence Aerospace LLC · Kennesaw, GABuilt 1963 · S/N 30-194N501RVSaunders Steven M · Elizabeth City, NCBuilt 2006 · S/N 90305N501SDNordeen Christopher L · Salinas, CABuilt 1986 · S/N 8088CN501TSFlying Tigers Flight School LLC · Houston, TXBuilt 1976 · S/N 17266839N501ZNorth Georgia Helicopters Inc · Calhoun, GAS/N 18-7836N50208Haus Jesse M · Fort Worth, TXBuilt 1974 · S/N 17264197N5020HBorreson Anthony · Mariposa, CABuilt 1975 · S/N 17265303N5020PThurston Steven C · Salisbury, NCBuilt 1958 · S/N 24-23N5020RMigliaccio Jason · Palm Bay, FLBuilt 1974 · S/N 17263261N5020SSchneider Robert R · Fort Benton, MTS/N 28R-35753N5020TBetlach Christopher Thomas · Kenmore, WABuilt 1972 · S/N 28R-7235175N5020WAndersen Richard W · Vail, AZBuilt 1961 · S/N 28-21N5021HAlamo Flyers LLC · Elmendorf, TXBuilt 1975 · S/N 17265304N5021RWax Sally G · Louisville, KYBuilt 1974 · S/N 17263262N5021ZFansler Rick L · Delta, OHBuilt 1961 · S/N 22-8636N50227Taylor Carter · Los Angeles, CABuilt 1942 · S/N 77143N5022WHovendick William P · Lander, WYBuilt 1961 · S/N 28-23N5023LIsland Hoppers Seaplanes 2 LLC · Orlando, FLBuilt 1971 · S/N 480N5023RStern Joseph L · Morrow, OHBuilt 1974 · S/N 17263264N5023SSummit Arrow Adventures LLC · Peyton, COBuilt 1970 · S/N 28R-35759N5023ZBauer Glenn D · Wishram, WABuilt 1961 · S/N 22-8638N50246Taubman Jason · Greenland, NHBuilt 1978 · S/N 1052-78N50247Haywood Charles E Jr · Valrico, FLS/N 437-78N5024PSun Aviation Inc · Santa Clara, CABuilt 1958 · S/N 24-27
Back to AD 90-04-06 R1