Skip to content

Registered aircraft · 6,915

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:71-13-01-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:71-13-01-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:71-13-01-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:71-13-01-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:71-13-01-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:71-13-01-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.

N301CAFreiday Robert A · Kingman, AZBuilt 1967 · S/N 32-40178 N301PKHubbs Matthew · Huntersville, NCBuilt 1973 · S/N 32-7440064 N301RTSather Dean L · Amarillo, TXBuilt 1982 · S/N 32R-8229068 N301TCSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2001 · S/N 3257257 N301TMTlwm Private Air LLC · Tampa, FLBuilt 1991 · S/N 27-0123 N3024DBas Part Sales LLC · Greeley, COBuilt 1978 · S/N 32R-7987057 N3024NDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1979 · S/N 32R-7987099 N30253Charter Rentals LLC · Mantua, OHS/N 32R-7887274 N3025LBeacon Aviation Flight Services LLC · Rogers, ARS/N 32R-7987092 N3025NTrue Auto Mart LLC · Belton, SCBuilt 1979 · S/N 32R-7987100 N3026CDowney Michael E · Dacono, COBuilt 1979 · S/N 32R-7987048 N3026DDirt World LLC · Boulder City, NVS/N 32R-7987058 N3028AJuliet Sierra Foxtrot LLC · Denver City, TXBuilt 1978 · S/N 32R-7987017 N3029LJenkins Jay P Jr · Amarillo, TXBuilt 1979 · S/N 32R-7987094 N302MMHidden Springs Aviation LLC · Perryville, KYBuilt 2008 · S/N 4692002 N302RTElston Josh Andrew · Deer Park, WABuilt 1982 · S/N 32R-8229039 N302WDAmado'S Holdings LLC · Rice, MNBuilt 2016 · S/N T20609241 N3030JJav Air LLC · Scottsdale, AZBuilt 1978 · S/N 32R-7987076 N3031APhoenix Flight LLC · Cave Creek, AZBuilt 1979 · S/N 32R-7987018 N30371Hartley Leonard T · Mineral Wells, TXBuilt 1978 · S/N 32R-7887277 N30381Harim John M · Dunbar, PAS/N 32R-7887278 N3038BJpsm Aircraft LLC · San Mateo, CABuilt 1978 · S/N 28-7911018 N303CGtair LLC · Ridgedale, MOBuilt 2005 · S/N 3257372 N303HBFly The Coop LLC · Newton, KSBuilt 2019 · S/N T20609577 N303KATjs3 Aviation LLC · Wilmington, DEBuilt 2013 · S/N T18209094 N30406Greenlaw Blair · Neptune Beach, FLBuilt 1978 · S/N 32R-7887279 N3040MAustin 206 Aviation LLC · Americus, GABuilt 2023 · S/N T20609732 N3041BHogue Evan M · University Place, WABuilt 1978 · S/N 32R-7985020 N3043BSimpson Jeffrey Scott · Charlotte, NCBuilt 1978 · S/N 32R-7987042 N3044KPetersen Alexander M · Laguna Beach, CABuilt 1979 · S/N 32-7940025 N3049KLodi Holdings LLC · Big Sky, MTBuilt 1978 · S/N 32R-7987090 N304LAK2 Sales LLC · Idaho Falls, IDS/N 4622033 N3050DFly 8gs LLC · Pompano Beach, FLS/N 32R-7987059 N30511N30511 LLC · Auburndale, FLBuilt 2003 · S/N 3255005 N3054HEconomy Supply Inc · Oilton, OKBuilt 1978 · S/N 32R-7987069 N3055FWilkinson Air LLC · Huntington, WVBuilt 1978 · S/N 32R-7987068 N3056DApplied Aviation LLC · Grain Valley, MOS/N 32R7987060 N3056RHassenpflug Derek G · Cincinnati, OHS/N 1598 N305JGAbeona-Adeona Aviation LLC · Wilmington, DEBuilt 2023 · S/N T20609718 N305MCShen Air II Inc · Mount Crawford, VABuilt 1973 · S/N 32-7340118 N305MTMtc Air LLC · Homestead, FLBuilt 2025 · S/N T20609809 N305WTToro Procurement LLC · San Angelo, TXBuilt 2015 · S/N T20609164 N305YWRichard L Richards P A Trustee · Coral Gables, FLBuilt 1977 · S/N 31-7852016 N3064CN3064c LLC · San Tan Valley, AZBuilt 2012 · S/N T18209084 N3065BVanator John D · Eaton Rapids, MIBuilt 1978 · S/N 32R-7987043 N30662Jandair LLC · Ennis, TXBuilt 2004 · S/N 3255023 N3066UAjh Aviation LLC · Monroe, LABuilt 2004 · S/N 3257341 N3067QKpw Enterprises Inc · Chula Vista, CABuilt 1977 · S/N 32R-7780279 N30689Pung Larry J · Hermitage, TNBuilt 1978 · S/N 32R-7885282 N3068THomeyer Joanne · Alexander, ARBuilt 1979 · S/N 32R-7987111

Back to AD 71-13-01 R1