Registered aircraft · 56,578

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-10-14-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-10-14-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-10-14-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-10-14-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-10-14-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-10-14-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.

N1742VGalion Air Inc · Galion, OHBuilt 1974 · S/N 17263735 N1742XR&C Aviation Partners LLC · Tucson, AZBuilt 1975 · S/N 21060763 N1743DCranton Larry J · Mesa, AZBuilt 1952 · S/N 20343 N1743FLittle Bird Airways LLC · Hamburg, NYBuilt 1966 · S/N 17255138 N1743LAir Inter LLC · Pittsburgh, PABuilt 2008 · S/N 172S10665 N1743RChronicle Aerospace Inc · Wilmington, DEBuilt 1974 · S/N 18502463 N1743SCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 172S12290 N1743VRegistered aircraftBuilt 1974 · S/N 17263736 N1744DJones William H Trustee · Wenden, AZBuilt 1951 · S/N 20187 N1744XDodson International Parts Inc · Rantoul, KSBuilt 1975 · S/N 21060765 N1745DStuczynski Jason S · Justin, TXBuilt 1951 · S/N 20188 N1745FClary David D · Elk Grove Village, ILBuilt 1966 · S/N 17255140 N1745RFiske James K · North Andover, MAFirst renewal noticeBuilt 1974 · S/N 18502465 N1745SCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 172S12291 N1746CGreen Gary Dale · Mccarthy, AKBuilt 1953 · S/N 30446 N1746ZThompson Nathan G · San Antonio, TXS/N 336-0046 N1747BDgpiper · Sheridan, WYBuilt 1980 · S/N 20700666 N1747CConatser Patrick M · Homeland, CABuilt 1953 · S/N 30447 N1747FSmith Jason F · Ronkonkoma, NYBuilt 1966 · S/N 17255142 N1747LCoco Aircraft Inc · Merritt Island, FLBuilt 2007 · S/N 17281489 N1747MMcmillan James D · Abilene, TXBuilt 1975 · S/N 18264425 N1747QAleyda Aviation LLC · Berlin, NJBuilt 1972 · S/N 15073047 N1748DWilliams Bobby G · Simi Valley, CABuilt 1951 · S/N 20191 N1748FManning Malcolm · Senatobia, MSBuilt 1966 · S/N 17255143 N1748RNorthstar Holdings LLC · Anchorage, AKBuilt 1980 · S/N U20605438 N1748UIliamna Air Taxi Inc · Iliamna, AKBuilt 1976 · S/N 20700348 N1748ZRanz Douglas R · West Bloomfield, MIBuilt 1962 · S/N 205-0047 N1749QScott Andrew F · Beaufort, SCBuilt 1971 · S/N 15073049 N1749UFreshwater Adventures Inc · Dillingham, AKBuilt 1976 · S/N 20700349 N1749VVance Nicholas D · Bluffton, OHS/N 17263737 N174AAdkins Charles D · Apopka, FLBuilt 1957 · S/N 34535 N174DVVosters Gary A · Nevada City, CABuilt 1977 · S/N 177RG1268 N174GFMarcus Air LLC · Plano, TXBuilt 1998 · S/N 17280532 N174HLarsen Kevin L · Firth, IDBuilt 1955 · S/N 31512 N174HAKlin Trin Collectibles LLC · Downers Grove, ILS/N 17272235 N174HFHeritage Asset Leasing LLC · Ronkonkoma, NYS/N 172S8257 N174JPGeary Michael Fredrick · Seguin, TXBuilt 1971 · S/N 17259850 N174LSN174ls LLC · Middlebury, CTBuilt 1976 · S/N 18503086 N174MEMaxxum Financial Group Inc · Destrehan, LABuilt 2000 · S/N 172S8452 N174THGh174th LLC · Jericho, NYBuilt 2020 · S/N 172S12442 N1750FLeggett Lee D · Murfreesboro, NCBuilt 1966 · S/N 17255145 N1750MChristensen Del A · Mattawa, WABuilt 1970 · S/N 33701350 N1750RShort James B · Anchorage, AKBuilt 1974 · S/N 18502470 N1750URenfro Michael W · Bethel, AKBuilt 1976 · S/N 20700350 N1751CFeaga Charles C Jr · Abbot, MES/N 30451 N1752CJarvis Jerry · Big Lake, AKS/N 30452 N1752TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12097 N1753DKlein John T · Austin, ARBuilt 1951 · S/N 20196 N1754TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12099 N1754USutton Aircraft Salvage LLC · Palmer, AKBuilt 1976 · S/N 20700354

Back to AD 79-10-14 R1