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

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

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.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N1103LAviation Advantage Inc · Tabor City, NCBuilt 1980 · S/N 1000812D N11056Northwest Helicopters I Inc · Olympia, WABuilt 1981 · S/N 310905D N110GLQualitair LLC Trustee · MichelstadtBuilt 1982 · S/N 6031 N110WGMeshoppen Air LLC · Tunkhannock, PABuilt 1978 · S/N 2367 N111ADSvp LLC · Missoula, MTBuilt 1980 · S/N 400704D N111HFPlane Fun Inc Tr Trustee · Snellville, GABuilt 1968 · S/N 208 N1128SAerial Organics LLC · Wilmington, DEBuilt 1980 · S/N 5009 N112LPRanger Aviation Leasing LLC · Wilmington, DES/N 3403 N113RLMarks Aviation Group LLC · Lafayette, LABuilt 1981 · S/N 3306 N114GSAviation Company Inc · Cheyenne, WYBuilt 1976 · S/N 34 N114HDWindward Aviation Inc · Puunene, HIBuilt 1978 · S/N 280261D N1158BAir Gov 1 LLC · Rome, NYBuilt 1996 · S/N 4431 N115ECSara Helicopters Inc · Wilmington, DEBuilt 1971 · S/N 110292S N115HDLaroche Aviation Services LLC · Bellaire, OHBuilt 1981 · S/N 711020D N115SUSignature Property Holdings LLC · Wilmington, DEBuilt 2021 · S/N 110868D N117HKSettan Corp · Goleta, CABuilt 1997 · S/N 4462 N118FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLBuilt 1991 · S/N 4182 N118TVInterstate Helicopter Inc · Bethany, OKBuilt 1979 · S/N 2844 N119TTaylor Robert T · Chehalis, WABuilt 1976 · S/N 760844S N11FHD H Helicopter Inc DBA · Sauget, ILBuilt 1993 · S/N 4270 N11ZXBig Bird Leasing Inc · Saint Peter, MNBuilt 1974 · S/N 640609S N1201WMagnum Aviation LLC · Goff, KSBuilt 1966 · S/N 7819 N1211MArchangelair LLC · Wilmington, DES/N 29002C N1219WMoes Crop Dusting Service Inc · Marysville, CABuilt 1975 · S/N 1843 N122BTNorth Wind Aviation LLC · Cottage Grove, ORBuilt 1989 · S/N 4053 N122JLotus Aviation LLC · Boring, ORBuilt 1976 · S/N 2035 N123MGHagedorn Aviation Inc · Columbus, OHBuilt 2001 · S/N 29003C N123NMAglk LLC · Lewes, DES/N 6702 N124EHJbp Aviation LLC · Henderson, NVS/N S559 N124PDH & O Helicopters Inc Trustee · Wilmington, DEBuilt 1992 · S/N 0502E N125KWAurora Aviation Services Inc · Delta Junction, AKBuilt 1989 · S/N 0336E N126KWHlh Leasing LLC · Wilmington, DEBuilt 1991 · S/N 0489E N128GCCga Holdings LLC · Kalispell, MTBuilt 1979 · S/N 6006 N12AAAllsouth Aviation LLC · Buford, GABuilt 1996 · S/N 52165 N12ATCustom Cub LLC · Keizer, ORBuilt 1974 · S/N 1329 N12BFHutter Charles G · Carson City, NVBuilt 1974 · S/N 61P-0162-003 N12SPNew York State Police · Albany, NYBuilt 2000 · S/N 49069 N12THHarding Tim · Bryan, TXS/N 0224E N130BHObrien Helicopters Inc · Lehigh Acres, FLBuilt 1975 · S/N 1776 N130JHRanger Aviation Leasing LLC · Wilmington, DES/N 4166 N131AEAtwood Aviation LLC · Pickerington, OHBuilt 1988 · S/N S787 N131ALQuicksilver Air Inc · Fairbanks, AKBuilt 1977 · S/N 1170230D N131NWEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1982 · S/N 1131D N133EHRed Bull North America Inc · Camarillo, CABuilt 1982 · S/N S-598 N133WHFour Creeks Aviation Inc · Visalia, CABuilt 1973 · S/N 1788 N134MSSunny Sky LLC · Stacyville, IABuilt 1977 · S/N 2226 N137AGTop Gun Precision Ag LLC · Skidmore, TXBuilt 1975 · S/N 1832 N137HSHelicopter Services Of Illinois LLC · Fisher, ILBuilt 1977 · S/N 2292 N137MScotts Helicopter Services Inc · Le Sueur, MNBuilt 1978 · S/N 2575 N138LHHelilease LLC · Lewes, DEBuilt 1989 · S/N 4063

Back to AD 79-21-01 R1