Skip to content

Registered aircraft · 5,443

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

N2317MHilton Head Flyers LLC · Liberty, SCBuilt 1977 · S/N 28-7816277 N231MAGolden Age N231ma LLC · Norwalk, IABuilt 2022 · S/N 2881564 N2321MPartridge John M · Danville, CABuilt 1977 · S/N 28-7816278 N2326VEby Thomas R · Winter Springs, FLBuilt 1985 · S/N 28-8590067 N232DXPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010032 N232MGGeorgia Aviation Authority · Eastman, GABuilt 2025 · S/N 2881983 N232SPTucker Adam C · Clermont, FLBuilt 1978 · S/N 28-7990205 N232TFAirmart Inc · Lexington, KYBuilt 2022 · S/N 2881550 N2331MSmith Ctr Kite Club Inc · Smith Center, KSBuilt 1977 · S/N 28-7890247 N2334MSunrise Aviation Inc · Ormond Beach, FLBuilt 1977 · S/N 28R-7837083 N233CBZions Credit Corp · Salt Lake City, UTBuilt 2020 · S/N 2881389 N234CPZan Am LLC · Findlay, OHBuilt 2000 · S/N 28-43369 N234KMMurray Edward L · Hoover, ALS/N 28-7990043 N234PAJuliet Two LLC · Ocean Ridge, FLBuilt 1978 · S/N 28-7816677 N235CCYale Companies LLC DBA · Indianapolis, INBuilt 2021 · S/N 2881504 N235FYSpace Coast Aircraft Co · Merritt Island, FLBuilt 1989 · S/N 2841285 N235PAGood Flight Aviation LLC · Stockton, CABuilt 1978 · S/N 28-7816678 N235SRDraco Flight School DBA · Chino, CABuilt 2003 · S/N 2842182 N235TPSvl Aviation LLC · Delray Beach, FLBuilt 1985 · S/N 28-8516036 N2361QLong Lawrence R · South Whitley, INS/N 28-7716100 N2366WAir-Mods Flight Academy · Robbinsville, NJS/N 28-8516046 N236BLPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010037 N236DProfessional Training Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 2843824 N236FYSpace Coast Aircraft Co · Merritt Island, FLBuilt 2000 · S/N 2842023 N236MGGeorgia Aviation Authority · Eastman, GABuilt 2025 · S/N 2881984 N236PAGreene James · Hudson, SDBuilt 1978 · S/N 28-7816679 N236ZKMaximum Ceiling Aviation LLC · Farmingdale, NYS/N 2843401 N2375MValentine Ronald F Jr · Santa Maria, CABuilt 1977 · S/N 28-7816280 N2377UCardinal Flight Systems LLC · Cary, NCBuilt 1979 · S/N 28-8016021 N2378UInternational Flight Academy LLC · Ft Worth, TXBuilt 1979 · S/N 28-8016022 N237FYSpace Coast Aircraft Co · Merritt Island, FLBuilt 1989 · S/N 2842015 N237MGGeorgia Aviation Authority · Eastman, GABuilt 2024 · S/N 2881815 N2380MPiggott William H · Madison, CTBuilt 1977 · S/N 28-7890249 N238FYSpace Coast Aircraft Inc · Merritt Island, FLBuilt 1989 · S/N 2841175 N238MGGeorgia Aviation Authority · Eastman, GABuilt 2024 · S/N 2881816 N238NDPlane Nonsense · Middletown, DEBuilt 2000 · S/N 2842101 N238TCTexas State Technical College · Waco, TXBuilt 2025 · S/N 28020238 N2391QNew Hamphire Flyers LLC · Lyme, NHBuilt 1977 · S/N 28-7790395 N2392QTwin Eagle Flying Club Inc · Pikeville, KYBuilt 1977 · S/N 28-7790396 N2394MOld Buzzard Ltd · Columbus, OHBuilt 1977 · S/N 28R-7837085 N2395VConfluence Systems Consulting Inc · San Jose, CAS/N 28-8590069 N239CWolvestown LLC · Humble, TXBuilt 2003 · S/N 2843581 N239JAHot Wings Aviation LLC · Indianapolis, INBuilt 2020 · S/N 28020009 N239MGGeorgia Aviation Authority · Eastman, GABuilt 2025 · S/N 2881868 N239NDPlane Nonsense Inc · Middletown, DEBuilt 2000 · S/N 2842100 N23DDK Tahoe Air LLC · Glendale, CABuilt 2023 · S/N 2881676 N23NANorthampton Aeronautics Inc · Northampton, MABuilt 1977 · S/N 28-7716036 N240AAFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881731 N240JAHot Wings Aviation LLC · Indianapolis, INBuilt 2020 · S/N 28020010 N240UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2024 · S/N 28020161

Back to AD 2016-07-21