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.

N260DPGreat Basin Advisors LLC · Truckee, CAS/N 009/62-002 N260LRCenterline Holdings · Camden, DEBuilt 1982 · S/N 3613 N2618WEnglish Air Service LLC · Georgetown, TXBuilt 1966 · S/N 6580 N261SPMbm Aviation Consultants Inc · Wilmington, DEBuilt 1988 · S/N 4033 N262WAWindward Aviation Inc · Puunene, HIBuilt 1979 · S/N 790554D N2650North Texas Helicopters Inc · Newark, TXBuilt 1979 · S/N 2650 N2672Reynolds Aviation LLC · Wills Point, TXBuilt 1992 · S/N E-2672 N267MWPacific Valley Aviation Inc · Arbuckle, CABuilt 1980 · S/N 3149 N2681RFarley Delbert · Victorville, CAS/N 2681 N26BL58d Leasing LLC · Plover, WIBuilt 1976 · S/N 2030 N26MVTjr Ltd · Excelsior, MNBuilt 1989 · S/N 4052 N26NKLsk Leasing LLC · Lewes, DEBuilt 1980 · S/N 3078 N272LHBlue Sky Air Services LLC · Wilmington, DEBuilt 1979 · S/N 075 N2751ACollective Aviation Services · Orient, IABuilt 1979 · S/N 2623 N27758Dragonfly Aviation LLC · Saint Ansgar, IABuilt 1979 · S/N 2791 N277RLSan Juan Aviation LLC · Wilmington, DEBuilt 1981 · S/N 3277 N27HXHelicopter Express LLC · Chamblee, GABuilt 1996 · S/N 53012 N28373Hornet International LLC · Picayune, MSBuilt 1974 · S/N 1496 N283XLThiel Air Care Inc · Chowchilla, CABuilt 1971 · S/N 715 N284CAOrgan Mountain Aviation Co LLC · Las Cruces, NMS/N 1578 N289RLL&R Investment Partners LLC · Wilmington, DES/N 3765 N28HTL&R Investment Partners LLC · Wilmington, DES/N 2840 N28LZLindemann Thomas · Gustine, CABuilt 1981 · S/N U20606531 N28UKOas2 LLC · Orlando, FLBuilt 1978 · S/N 2475 N290LHLarson Helicopters LLC · Perham, MNBuilt 1977 · S/N 2186 N292BHAbc Helicopters Inc · Jefferson, WIBuilt 1992 · S/N 4255 N2944WTrinkle Avition LLC · Kingsburg, CABuilt 1971 · S/N 748 N2949WThiel Air Care Inc · Chowchilla, CABuilt 1972 · S/N 824 N2963WRegistered aircraftN-number assigned, not yet registeredS/N 817 N297CAHelicopter Services Of Illinois LLC · Fisher, ILBuilt 1974 · S/N 1453 N297ECounty Of Kern · Bakersfield, CAS/N 197E N298PPGillespie Flying Services LLC · Trenton, SCBuilt 1982 · S/N 0006E N2995WScotts Helicopter Services Inc · Le Sueur, MNBuilt 1973 · S/N 1192 N299DRKings County Sheriffs Office · Hanford, CABuilt 1986 · S/N 196E N29SHelicopters Inc · Cahokia, ILBuilt 1995 · S/N 4378 N2BQRare Aircraft Ltd · Faribault, MNBuilt 1996 · S/N 4392 N301SDHarrison County Sheriffs Department · Gulfport, MSBuilt 1967 · S/N 1070131 N302HFCity And County Of Honolulu · Honolulu, HIBuilt 1992 · S/N LN023 N303HFHonolulu Fire Department · Honolulu, HIBuilt 1994 · S/N LN064 N304PDCity Of Tucson Police Department · Tucson, AZBuilt 1999 · S/N 4525 N3051QCharlie Helicopter Company LLC · Sierra Blanca, TXBuilt 1974 · S/N 540601S N305GLTickety Boo Consulting LLC · Whitefish, MTBuilt 1979 · S/N 2790 N305JEDah Aircraft LLC · Georgetown, SCBuilt 1982 · S/N 1194D N306FWEgli Air Haul Inc · King Salmon, AKBuilt 1986 · S/N 3940 N307KHGm Leasing Company LLC · Broussard, LABuilt 1997 · S/N 53172 N3094GScotts Helicopter Services Inc · Le Sueur, MNBuilt 1965 · S/N 3361 N313APWav Series LLC · Batavia, ILBuilt 1981 · S/N 3471 N313JPPerell John · Miami Beach, FLBuilt 1972 · S/N 1120428S N316CFLeading Edge Flight Academy LLC · Bend, ORBuilt 1977 · S/N 2264 N316HKHawkeye Holdings LLC · Lyndon, KSBuilt 1979 · S/N 390479D

Back to AD 79-21-01 R1