Skip to content

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.

N1314SAviation Specialty Services LLC · Beaufort, NCS/N 33701902 N1314UKilgore Don H · Jasper, ALBuilt 1982 · S/N 21064685 N13151F N A Aviation LLC · Wakefield, MABuilt 2006 · S/N 172S10344 N13152Quirrion Linton A · Jay, MEBuilt 1973 · S/N 17262531 N13154Howell James W · Boise, IDBuilt 1973 · S/N 17262533 N13156Mph Aviation LLC · Eastanollee, GABuilt 1973 · S/N 17262535 N13157Red River Flyers Inc · Wahpeton, NDBuilt 1973 · S/N 17262536 N1315ETada Aero LLC · Worthington, OHBuilt 1978 · S/N 17270951 N1315FApsey Bradley D · Deckerville, MIBuilt 1966 · S/N 17254810 N1315MSpitzer John R · Rockford, ILBuilt 1975 · S/N 18264285 N1315QWhite Beth A · Keene, NHBuilt 1971 · S/N 15072615 N1315UMcgonagill Billy D · Mount Pleasant, TXBuilt 1976 · S/N 17267004 N13160Dey James M · Waterford, MIBuilt 1973 · S/N 17262538 N13164Jameson Kelly J · Chappell Hill, TXBuilt 1973 · S/N 17262542 N131691521 LLC · Antigo, WIBuilt 1973 · S/N 17262546 N13171Tagle Robert J · San Antonio, TXBuilt 1973 · S/N 17262548 N13178Tappan Jay M · St Helens, ORBuilt 1973 · S/N 17262549 N1317DBaer Monte Wayne · Ronan, MTS/N 19893 N1317EAbove And Beyond Aviation LLC · Austin, TXBuilt 1978 · S/N 17270952 N1317MScallcess LLC · Boynton Beach, FLBuilt 1975 · S/N 18264287 N1317SWarrior Ink · Whittier, CABuilt 1976 · S/N 18264881 N1317ULondondeery Flying Club Inc · Litchfield, NHBuilt 1976 · S/N 17267006 N13180Skyward Fleet Solutions LLC · Granite Bay, CABuilt 1976 · S/N 17702402 N13182Spillman Aviation LLC · Colorado Springs, COBuilt 1973 · S/N 17262552 N13185Good Flight LLC · Colchester, CTBuilt 1973 · S/N 17262554 N13187Fly Aviation Corp · Wilmington, DES/N 17262556 N1318DBott Christopher L · Pilot Point, TXBuilt 1951 · S/N 19894 N1318PDye Paul C · Mc Neal, AZBuilt 1965 · S/N 185-0871 N1318QMustang Sally Aviation LLC · Camden, SCBuilt 2008 · S/N 172S10657 N13190Donham Rita M · Cora, WYBuilt 1973 · S/N 17262559 N13196Frederick Christopher N · North Mankato, MNBuilt 1973 · S/N 17262563 N1319EEnergy Transfer Aviation LLC · Spring, TXBuilt 1982 · S/N 18268173 N1319LOttlinger Robert L · Ormond Beach, FLBuilt 1977 · S/N 33701811 N1319QOutman Christopher · Lowell, MIBuilt 1971 · S/N 15072619 N1319UMarsh John E · Washington, DCS/N 17267008 N1319YWinston William F · Lake Stevens, WABuilt 1961 · S/N 17249019 N131AZSuraair Holdings Inc · Wilmington, DEBuilt 2012 · S/N 172S11165 N131ELantz Herman D · Saint Clairsville, OHBuilt 1955 · S/N 31806 N131FROptic Air LLC · Sioux Center, IAS/N 17276252 N131JDMccurry Patty Trustee · Ocala, FLBuilt 1978 · S/N 17270668 N131MTWings Over Texas Holdings LLC · Denton, TXBuilt 1973 · S/N 17262525 N131TTCharlie Kilo Enterprises Inc · Melbourne, FLBuilt 1979 · S/N U20605010 N131VUMalisa Michael D · Goodyear, AZBuilt 1985 · S/N 172RG1191 N131WCVoigt Aviation Inc · Park Rapids, MNS/N 20608034 N131YBeli Christopher J · Oregon, OHS/N 18052073 N13200Classic Aircraft Sales LLC · Weyers Cave, VABuilt 1973 · S/N 17262567 N13203Iowa Lakes Community College · Estherville, IABuilt 1973 · S/N 17262570 N13205Hoecher Robert T · Anchorage, AKBuilt 1973 · S/N 17262572 N13206Bishop Ronald E · Rolling Hills, CABuilt 1973 · S/N 17262573 N13208Thirty-Two Gulf Flying Club · Reston, VABuilt 1973 · S/N 17262575

Back to AD 79-10-14 R1