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.

N21EBSunview Flying Service LLC · Jordan, NYBuilt 1974 · S/N 177RG0589 N21EWRountree Christopher B · Burbank, CAS/N 18255335 N21FFHor Aviation LLC · Harrisburg, PABuilt 1969 · S/N 18260179 N21LDCaswell Bruce · Charleston, WVBuilt 1963 · S/N 18255173 N21PVPeterson Kirk A · Nixa, MOBuilt 1966 · S/N 18256921 N21RGMacair Aviation LLC · Xenia, OHBuilt 1969 · S/N 20700066 N21RPJ-Dawgs Aviation LLC · Greenville, NCS/N 17252591 N21TBAughinbaugh Christopher · Rancho Cordova, CABuilt 1966 · S/N 18257128 N22001Fisher Robert G Jr · Hodges, SCBuilt 1967 · S/N 15068000 N22003Hall David D · Des Moines, WAS/N 15068002 N22009Dundon Nick · Bozeman, MTBuilt 1967 · S/N 15068006 N22014Sun Valley Aviation Inc · Harlingen, TXBuilt 1967 · S/N 15068010 N22016Kiehle Ingrid E · Anchorage, AKS/N 15068012 N22019Swindell Daniel J · Greensburg, PABuilt 1967 · S/N 15068014 N2201YInternational Air Services Inc Trustee · Carson City, NVBuilt 1967 · S/N 17700001 N22025Scheck Christopher R · Troutdale, ORBuilt 1967 · S/N 15068016 N22027Lyles Bobbi L · Broken Arrow, OKBuilt 1967 · S/N 15068018 N22029Youth Eagles Aviation · Elk Grove, CAS/N 15068020 N2202JMartin Paul H · Willows, CABuilt 1966 · S/N 15065402 N22037Johanson Jonas P · Groveland, CAS/N 15068023 N22039Barkan James · Las Vegas, NVS/N 15068025 N22049Air Carriage Inc · Chico, CAS/N 15068030 N2204YEagle Sky Patrol Inc · Deadwood, SDS/N 17700004 N22053Stoddard Greg E · Anchorage, AKBuilt 1967 · S/N 15068031 N22060Watson Thomas G · Sunderland, MAS/N 15068036 N2206RKahonees Travel Services LLC · Pleasanton, TXBuilt 1968 · S/N T210-0356 N2206YSanders Andrew · Livingston, MTBuilt 1967 · S/N 17700006 N22070Mcmullen Christopher · Holt, MOBuilt 1967 · S/N 15068043 N22076Glacier Flight Training LLC · Whitefish, MTBuilt 1967 · S/N 15068047 N22078Line Electric Company LLC · Lake City, FLBuilt 1967 · S/N 15068049 N2207JCoolidge Marvin L · Newberg, ORBuilt 1966 · S/N 15065407 N22085Chandler Judd S · Corryton, TNBuilt 1967 · S/N 15068055 N22086Jackson Allan D · Wetumpka, ALS/N 15068056 N22090Aces Aviation LLC · Buffdale, UTBuilt 1967 · S/N 15068058 N2209RPilotsgirl LLC · Goldsboro, NCBuilt 1968 · S/N T210-0359 N220FBCulbertson William Theodore · Helena, MTBuilt 1967 · S/N R172-0221 N220MEBoyle Flying Service Inc · Boyle, MSBuilt 1967 · S/N U206-0797 N22102Registration Pending · Metairie, LARegistration pendingS/N 15068063 N22106Andreu Kenneth J · Valhalla, NYS/N 15068064 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 N2211YGayle Randall K · Houston, TXBuilt 1967 · S/N 17700011 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 N2212YSteffy Richard L · Annville, PABuilt 1967 · S/N 17700012 N22130Kall Joseph F · Bozeman, MTBuilt 1967 · S/N 15068079 N22135Rosales Ruano Irving A · Plantation, FLS/N 15068084

Back to AD 72-03-03 R3