OpenAirDocs.org
AD 79-21-01 R1

Registered aircraft · 1,074

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:79-21-01-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:79-21-01-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.

N40DVNordstrom Eric Trustee · Anchorage, AKBuilt 1982 · S/N U20606493N40MCScotts Helicopter Service · Le Sueur, MNBuilt 1970 · S/N 563N410SCAlfheim II LLC · Menomonee Falls, WIBuilt 1998 · S/N 5026N411JHHeidrick Joe · Woodland, CAS/N 0193EN411WJNorthwest 60 LLC · Kalispell, MTBuilt 2014 · S/N 0620EN4155KPereira Alfred R Jr · Valley Springs, CAS/N 1053N415WCWilson Construction Co · Canby, ORBuilt 1981 · S/N 0005EN41AJEnglish Air Service LLC · Georgetown, TXBuilt 1978 · S/N 480299DN41EWMemphis Police Department · Memphis, TNBuilt 1989 · S/N 4044N41PHTobler Hans P · Anchorage, AKBuilt 1974 · S/N 1544N41WEEastward Aviation Inc · Eagle Lake, TXS/N 3850N420KTRegistered aircraftBuilt 2008 · S/N 0582EN420WPQualitair LLC Trustee · MichelstadtBuilt 2002 · S/N 29004CN421KY250 Logistics LLC · Mount Pleasant, TXBuilt 2009 · S/N 0594EN421SPKentucky State Police · Frankfort, KYBuilt 2008 · S/N 0714FFN4237MTrideca Vertical Solutions LLC · Dallas, TXBuilt 1989 · S/N 4055N425WCWilson Construction Co Inc · Canby, ORS/N 0268EN4265JRatcliff Dustin · Saltville, VABuilt 1979 · S/N 790542DN4292DUrocopters Inc · Lancaster, CAS/N 0364EN42FFBeef Aviation LLC · Bradenton, FLBuilt 1984 · S/N 0141EN42LHFly Hangar 13 LLC · Mico, TXBuilt 1981 · S/N EA-163N430AGMcmahon Helicopter Services Inc · Canton, MIBuilt 1998 · S/N 49045N430JRAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1991 · S/N 7640N430NYMcmahon Helicopter Services Inc · Canton, MIBuilt 2000 · S/N 49068N430STHigh Performance Helicopters Corp · Crestline, CABuilt 2000 · S/N 49071N430VPAerotrust Services Corp Trustee · Wilmington, DES/N 49005N43142Scotts Helicopter Services Inc · Le Sueur, MNBuilt 1977 · S/N 1577N431CAChem-Air LLC · Shreveport, LABuilt 1978 · S/N 2517N431HFHeliflite Shares LLC · Newark, NJBuilt 1999 · S/N 49051N432RDAirdine LLC · San Francisco, CABuilt 2002 · S/N 5039N432TVSky Choppers LLC · Seneca, KSBuilt 1981 · S/N 3286N43HHJohnson Flying Service LLC · Exira, IABuilt 1975 · S/N 1585N43MAMinuteman Aviation Inc · Missoula, MTBuilt 1991 · S/N 4156N441EAEdgefield Aviation LLC · Sandy, ORBuilt 1972 · S/N 71-20860N4445HBell Textron Inc · Fort Worth, TXBuilt 1998 · S/N 4493N444JBAir First LLC · Pembroke, NHBuilt 1971 · S/N 71-20362N444TVScotts Helicopter Service Inc · Le Sueur, MNBuilt 1981 · S/N 3501N445Wisk Aero LLC · Mountain View, CABuilt 1993 · S/N 4285N4452Bravo Aviation LLC · Chicago, ILBuilt 1973 · S/N 1086N445SAvitek Inc · Plymouth, MIS/N 230445SN448EAEdgefield Aviation LLC · Sandy, ORBuilt 1974 · S/N 1495N450AGInternational Air Services Inc Trustee · Carson City, NVBuilt 1971 · S/N 1090202MN450XPlane Enjoyment LLC · Dover, MABuilt 1990 · S/N 12001CN451HAIron Horse Aviation LLC · Marshalltown, IABuilt 1979 · S/N 490484DN454JHJack Harter Helicopters Inc · Lihue, HIBuilt 1991 · S/N 0454EN454MSCb Couch Inc · Walcott, ARBuilt 1975 · S/N 1627N458HWHeliwild Investments LLC · Austin, TXBuilt 1979 · S/N 390483DN458PBBarbaro Paul G · Argyle, TXBuilt 1985 · S/N 0123EN463RARanger Aviation Leasing LLC · Wilmington, DEBuilt 1997 · S/N 4463N467PHPhi Health LLC · Tempe, AZBuilt 1997 · S/N 53142
Back to AD 79-21-01 R1