Skip to content

Registered aircraft · 17,027

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:72-03-03-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3') 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:72-03-03-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
  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:72-03-03-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
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.

N3489TBlue Skies Aviation LLC · Belfast, MEBuilt 1968 · S/N 17700789 N348SAPutman James R Jr · Kernersville, NCBuilt 1974 · S/N 17702065 N348SRK & K Commercial Leasing LLC · Indiana, PABuilt 1972 · S/N 177RG0267 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 N3490RFreiberger Gary D · Fort Lauderdale, FLBuilt 1968 · S/N 18258790 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 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 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 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 N34959Scales Richard O · Signal Mountain, TNBuilt 1974 · S/N 17702116 N3495JWatson John T Jr · Fairfield, CABuilt 1967 · S/N 15066195 N3495LSaqul'Aq Air LLC · Coupeville, WABuilt 1967 · S/N U206-0795 N3495RC182 Flyers LLC · Las Cruces, NMS/N 18258795 N3495S3495s LLC · Prescott, AZBuilt 1964 · S/N 18255895 N34964Rayle John R · Aurora, OHBuilt 1974 · S/N 17702118 N34966Williams John D · Geneva, OHBuilt 1974 · S/N 17702119 N34967Brady Francis T · Meridian, IDBuilt 1974 · S/N 17702120 N34969Lagrone Rex F · Filer, IDBuilt 1976 · S/N 177RG1033 N3496TSchwenk Franklin · Ben Wheeler, TXBuilt 1968 · S/N 17700796 N34973Spear Aviation LLC · East China, MIS/N 17702125 N34976Mungenast Andrew J Jr · Lancaster, TXBuilt 1974 · S/N 17702128 N34977Holtzman Gary E · Van Alstyne, TXBuilt 1974 · S/N 17702129

Back to AD 72-03-03 R3