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.

N220NYCa Aviation 172 LLC · Santa Barbara, CABuilt 1974 · S/N 17263763 N220TCLanger Brent A · Owatonna, MNBuilt 1973 · S/N 18502153 N220TJJaco Oil Co · Bakersfield, CAS/N 21063139 N220WBWells Propane Inc · Wells, NVBuilt 1974 · S/N 210-60194 N220WCJeffery & Weiss Holdings LLC · Long Beach, CAS/N 172S10519 N22101Propwash Aviation LLC · Midland, MIBuilt 1974 · S/N 17264055 N22102Registration Pending · Metairie, LARegistration pendingS/N 15068063 N22106Andreu Kenneth J · Valhalla, NYS/N 15068064 N2210DSample Richard F · Ellensburg, WAS/N 20362 N2210JAmes Stephen A · Scottsdale, AZBuilt 1966 · S/N 15065410 N2210RCarroll James K · Paso Robles, CAS/N T210-0360 N22110Schmitt Rudy · Brookshire, TXS/N 15068066 N22115Cummins Michael P · University Park, MDBuilt 1967 · S/N 15068069 N2211DKuhn Michael D · Knapp, WIBuilt 1952 · S/N 20363 N2211GKoepplin Ricky G · Missoula, MTBuilt 1958 · S/N 51511 N2211YGayle Randall K · Houston, TXBuilt 1967 · S/N 17700011 N22121Registration Pending · Georgetown, TXRegistration pendingBuilt 1972 · S/N 21059711 N22123Hughes James H · Northlake, TXBuilt 1967 · S/N 15068074 N22128Sale Reported · Royal, ARSale reported, pending cancellationBuilt 1967 · S/N 15068077 N22129Morrison Dwayne L · Columbia, SCBuilt 1967 · S/N 15068078 N2212WCleveland Frank W · Quinhagak, AKBuilt 1978 · S/N 17271516 N2212YSteffy Richard L · Annville, PABuilt 1967 · S/N 17700012 N22130Kall Joseph F · Bozeman, MTBuilt 1967 · S/N 15068079 N22131Kraxberger Rick R · Kasilof, AKBuilt 1976 · S/N 18503074 N22135Rosales Ruano Irving A · Plantation, FLS/N 15068084 N22138Obert Robert V · Dunnellon, FLBuilt 1967 · S/N 15068086 N2213CTruffer Martin · Fairbanks, AKBuilt 1953 · S/N 30513 N2213GAnzion Susan K · Nerstrand, MNBuilt 1958 · S/N 51513 N2213JKlemp Darrel D · Bonduel, WIBuilt 1966 · S/N 15065413 N22142Cummings Ezekiel · San Antonio, TXBuilt 1967 · S/N 15068090 N22145Mcdowell Jhonathon P · Lake Alfred, FLBuilt 1967 · S/N 15068093 N22146Star Voyages LLC · Kissimmee, FLBuilt 1967 · S/N 15068094 N22147Morris Gregory A · Arlington, TXFirst renewal noticeBuilt 1967 · S/N 15068095 N2214CMarks Richard J IV · Norway, MEBuilt 1953 · S/N 30514 N2214GGanfield Roger A · Guernsey, WYBuilt 1958 · S/N 51514 N2214LBlue Bird Aviation LLC · San Jose, CABuilt 2005 · S/N 18281718 N2214YRegistration Pending · Tampa, FLRegistration pendingBuilt 1967 · S/N 17700014 N22150Cody Edward H · Benton City, WABuilt 1967 · S/N 15068098 N22151Soren Sky LLC · Riverside, CAS/N 15068099 N22153Carter Gary J · Manlius, NYBuilt 1967 · S/N 15068101 N22155Anady Aviation LLC · Hemet, CABuilt 1967 · S/N 15068103 N22157Potter Colin J · Piedmont, SDBuilt 1967 · S/N 15068104 N22158Million John B · Westminster, MDBuilt 1967 · S/N 15068105 N22159Registration Pending · Phoenix, AZRegistration pending, canceledBuilt 1967 · S/N 15068106 N2215JRogers Gary A · Novi, MIBuilt 1966 · S/N 15065415 N2215TBackcountry Wagons LLC · Kalispell, MTBuilt 1968 · S/N 185-1367 N22160Evert Linda L · Golden Valley, MNBuilt 1967 · S/N 15068107 N22162Red Oak Commuter LLC · Red Oak, IABuilt 1967 · S/N 15068108 N2216CAero Mark Inc · Idaho Falls, IDBuilt 1953 · S/N 30516 N2216FSummit North LLC · Anchorage, AKBuilt 1982 · S/N U20606504

Back to AD 79-10-14 R1