OpenAirDocs.org
AD 90-04-06 R1

Registered aircraft · 68,369

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.

N209ASCherokee Bill Aerovation LLC · Gainesville, GABuilt 2005 · S/N 40.554N209BZHipple Patrick · Brecksville, OHS/N SS890830N209CCCampbell Aviation Inc · Dutton, MTBuilt 1997 · S/N 20209N209DBCreedon William P · Escondido, CABuilt 1971 · S/N 139N209DPBke Air LLC · Newnan, GABuilt 1977 · S/N 17270158N209DSMassman Enterprises LLC · River Hills, WIBuilt 2004 · S/N 40.409N209ESSweeney Edward C · Parrish, FLBuilt 1971 · S/N 146N209HVAnderson Scott · Salem, ORBuilt 1979 · S/N 17272302N209JRegistered aircraftBuilt 1982 · S/N 28-8216153N209JFStock James D · Deer Park, WABuilt 1967 · S/N 76N209JGPotter Gary W · Abilene, TXBuilt 1987 · S/N 1N209JRSweeney Edward · Parrish, FLBuilt 1971 · S/N 166N209JVPlahn Paul H · Minneapolis, MNBuilt 1971 · S/N 148N209MKTampa Helicopter Services LLC · Dover, FLBuilt 2010 · S/N S2175N209MSLand & Air Surveying Inc · Malibu, CABuilt 1988 · S/N S1303N209MTTerrell Michael A · Canby, ORBuilt 2009 · S/N 71202N209PTSilver Express DBA · Miami, FLBuilt 1979 · S/N 44-7995239N209SAInternational Air Services Inc Owner Trustee · Carson City, NVS/N 22-8448N209SCInternational Air Services Inc Trustee · Carson City, NVBuilt 1976 · S/N 28-7625115N209SFWhitaker Alvin E · Waterloo, WIBuilt 1971 · S/N 142N209WAPatstone Arthur · Port Orange, FLFirst renewal noticeBuilt 1971 · S/N 122N20ALilbit Industries LLC · Oklahoma City, OKBuilt 1955 · S/N 23-396N20AAGrand River Aviation LLC · Kremmling, COBuilt 1968 · S/N 17256596N20AJTwigg Brett · Lincoln, ALBuilt 1985 · S/N 475N20AKAuer Matthew J · Anchorage, AKBuilt 2005 · S/N 5771N20ALHarrington Mark · West Milford, NJBuilt 1991 · S/N 46N20AVRocco Leroy · Ceresco, MIBuilt 1976 · S/N 177RG-0888N20AXHehmann Richard J · Belleville, ILS/N 177RG1160N20BGHull Matthew E · Walnut Creek, CABuilt 1984 · S/N GLODFELTY 001N20CEOslick Rochelle · Oxnard, CABuilt 1993 · S/N GLOVER-0001N20CMTaylor Thomas D · Harper, TXBuilt 1951 · S/N 18-910N20CTN20ctid LLC · Pocatello, IDBuilt 1978 · S/N 152-81952N20CUCosta Flying Service Inc · Painted Post, NYBuilt 1980 · S/N 172RG0323N20DKFlight Surgeon LLC · Fayetteville, ARBuilt 1976 · S/N 17266836N20DUWings Of Hope · Chesterfield, MOBuilt 1985 · S/N 529N20EA4-D Aviation Consulting LLC · Wilmington, DEBuilt 2001 · S/N 007N20EHUnzicker Keith R · Benson, ILBuilt 1966 · S/N 1090N20ELJrhav LLC · Chassell, MIS/N 622N20EMReifert Todd · Louisville, KYBuilt 1981 · S/N 0001N20ETClear Skies Avionics Inc · Clearwater, FLS/N 621N20EUWerking John William III · New Windsor, MDS/N 628N20FLowden Howard J · Rome, GABuilt 1965 · S/N TD-623N20FSDahm Douglas W · Discovery Bay, CAS/N 23122N20FVRogers Robert D Jr · Keller, TXBuilt 1986 · S/N 642N20GCCrow Gregory D · Windom, MNBuilt 2000 · S/N 6-3722N20GGHofer Danny C · Huron, SDBuilt 1978 · S/N 28-7916032N20GWWyatt John B · Culpeper, VABuilt 1977 · S/N 1N20HTRed Arrow Aviation LLC · Santa Teresa, NMBuilt 1969 · S/N 17258306N20HURussell Michael E · Sumner, TXBuilt 2025 · S/N 3455N20HYTack John A · Wasilla, AKBuilt 1998 · S/N 2001
Back to AD 90-04-06 R1