Skip to content

Registered aircraft · 56,580

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.

N348CHAce Flight Center Inc · St Thomas, VIS/N 17266564 N348CPHaddock Tracey P · Kingstree, SCBuilt 1998 · S/N 17280348 N348MEBlackstone Aviation LLC · Irvine, CAFirst renewal noticeBuilt 2000 · S/N 172S8582 N348SAPutman James R Jr · Kernersville, NCBuilt 1974 · S/N 17702065 N348SPSilverhawk Aviation Academy LLC · Caldwell, IDBuilt 1999 · S/N 172S8273 N348SRK & K Commercial Leasing LLC · Indiana, PABuilt 1972 · S/N 177RG0267 N348TCWilliams Ryan D · Panama City, FLBuilt 2004 · S/N 18281434 N34900Payne Richard L · Flint Hill, VABuilt 1974 · S/N 17702074 N34901Brannan Christopher L · Garberville, CAS/N 17702075 N34904Carolina Sky Aviation LLC · Charleston, SCBuilt 1974 · S/N 17702078 N34905Taylor Made Enterprises LLC · Mesa, AZBuilt 1974 · S/N 17702079 N34908Registered aircraftBuilt 1974 · S/N 17702082 N34909Thomes Gregory L · Maple Lake, MNBuilt 1974 · S/N 17702083 N3490FRegistered aircraftBuilt 1966 · S/N 18257490 N3490GTucker Shad E · Sandia, TXS/N 51790 N3490RFreiberger Gary D · Fort Lauderdale, FLBuilt 1968 · S/N 18258790 N3490YRouse & Rouse-Houck LLC · Gunnison, COBuilt 1968 · S/N 18051990 N34910Jackson Flight Associates Inc · Sherburn, MNBuilt 1974 · S/N 17702084 N34914Steele Craig S · Las Vegas, NVBuilt 1976 · S/N 177RG1020 N34915Roberts David C · Sidney, IABuilt 1974 · S/N 17702088 N34916Denardo Stephen B · Cranston, RIBuilt 1974 · S/N 17702089 N34917Chester Zechariah L · Eau Claire, MIBuilt 1974 · S/N 17702090 N3491CNorth Sound Aviation Inc · Sedro Woolley, WABuilt 1954 · S/N 26534 N3491JNightknight LLC · Palm Bay, FLS/N 15066191 N3491SApollo Aviation Inc · Mound, MNFirst renewal noticeBuilt 1964 · S/N 18255891 N3491UMalchoff Kevin R · Lake View, NYBuilt 1963 · S/N 18254891 N34924Manning Rolla G Jr · Las Vegas, NVBuilt 1976 · S/N 177RG1022 N34927Brown Donald M · Eastsound, WABuilt 1974 · S/N 17702094 N34929Geister Ryan · Alto, MIBuilt 1974 · S/N 17702095 N3492CPiscoya Thomas G · Anchorage, AKBuilt 1954 · S/N 26535 N3492TBell Anthony J · Avondale, AZBuilt 1968 · S/N 17700792 N3492UMaligator Air LLC · Missoula, MTBuilt 1963 · S/N 18254892 N34931Moyer David R · Souderton, PABuilt 1974 · S/N 17702097 N34934Rider Nelson F · Ulysses, KSBuilt 1974 · S/N 17702100 N34935Mujeeb Altaf · Santa Rosa, CAS/N 17702101 N34936Danielson Wade W · Burbank, CABuilt 1976 · S/N 177RG1025 N3493CLumland Properties LLC · Winchester, VAS/N 26536 N3493SCola William Patrick · Colfax, CABuilt 1964 · S/N 18255893 N34940Murray Darrell J · Fallbrook, CAS/N 17702105 N34941Mosley Timothy D DBA · Calhoun, KYBuilt 1974 · S/N 17702106 N34943Cardco Aviation LLC · Wilmington, DES/N 17702108 N349445 Dimension Ltd · Bradenton, FLBuilt 1976 · S/N 177RG1027 N34947Nelson Kirk M · Kenosha, WIBuilt 1976 · S/N 177RG1028 N34949Ktech Enterprises Inc · St George, UTBuilt 1976 · S/N 177RG1030 N3494FParadise Aviation LLC · Shoreline, WABuilt 1966 · S/N 18257494 N3494SLadder Livestock Company LLC · Savery, WYS/N 18255894 N3494YAltitude Fix Aviation LLC · Mesa, AZS/N 18051994 N34959Scales Richard O · Signal Mountain, TNBuilt 1974 · S/N 17702116 N3495DBruck Solomon A · Van Nuys, CABuilt 1955 · S/N 27038 N3495JWatson John T Jr · Fairfield, CABuilt 1967 · S/N 15066195

Back to AD 79-10-14 R1