Skip to content

Registered aircraft · 5,462

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.

N2232WJkj Aviation · Wilmington, NCBuilt 1979 · S/N 28-7916334 N2233BRollin Virginie C · Mountain House, CABuilt 1978 · S/N 28-7816598 N2233CFreeland Robert D · Victor, MTBuilt 1978 · S/N 28-7990147 N2233WMiloud Chadd K · Fort Worth, TXS/N 28-7916335 N2233XSpector Arnold · Stamford, CTBuilt 1979 · S/N 28-7990368 N2234FMoore Aviation LLC · Cedar Springs, MIBuilt 1978 · S/N 28-7990207 N2235BConner W Larry · Los Lunas, NMBuilt 1978 · S/N 28-7916120 N2236GParis Air Inc · Vero Beach, FLBuilt 1978 · S/N 28-7916215 N2236WMiloud Chadd K · Fort Worth, TXBuilt 1979 · S/N 28-7916337 N2237KCarolina Air LLC · New London, NCBuilt 1978 · S/N 28-7916232 N2237TSchmelzle Michael O · Shrewsbury, MOBuilt 1979 · S/N 28-7916302 N2238GRupp Aviation LLC · O Fallon, MOBuilt 1979 · S/N 28-7990418 N223GHMeridian Aircraft LLC · Wilmington, DES/N 2881542 N223WWSan Diego Flight Training Inc · San Diego, CABuilt 1978 · S/N 28R-7837251 N223YZMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881536 N223ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881608 N2240GThunderbird Aircraft Company · Bloomington, MNBuilt 1978 · S/N 28-7916217 N2240KBurnet David A · Quinton, ALBuilt 1978 · S/N 28-7916233 N2241GOwens Wilbur · Rch Palos Vrd, CABuilt 1978 · S/N 28-7990229 N2241KFlickinger Charles · Hermitage, PABuilt 1978 · S/N 28-7916236 N2241WRonlin Inc · Kissimmee, FLBuilt 1979 · S/N 28-7916338 N2241YHenault Benjamin · Archdale, NCBuilt 1979 · S/N 28-7990386 N2243PEasterling Richard V DBA · Berkeley, CABuilt 1979 · S/N 28-7990295 N2244MParis Air Inc · Vero Beach, FLBuilt 1977 · S/N 28-7816261 N2244VSouthern Colorado Flight Professionals LLC · Pueblo, COBuilt 1979 · S/N 28-7916329 N2245KPfeiffer Carl A Trustee · Moline, ILBuilt 1978 · S/N 28-7916237 N2245UFarris Gregory A · Chesterfield, MOBuilt 1979 · S/N 28-7916133 N2245WDorans Aviation LLC · Yardley, PABuilt 1979 · S/N 28-7990354 N22473Miller Aviation Group LLC · Coon Rapids, MNBuilt 1978 · S/N 28-7916071 N2247DSky Venture Inc · Franklin, WIS/N 28-7990168 N2247KSkyline Solutions Unlimited LLC · Edgewater, FLBuilt 1978 · S/N 28-7916238 N2247MCamp Randall · Duncan, SCBuilt 1977 · S/N 28R-7837073 N2248D2 Wings LLC · Noblesville, INS/N 28-7990169 N2248UNorth Central Flight Center LLC · Warwick, RIFirst renewal noticeBuilt 1979 · S/N 28-7916316 N2249KGarner William B · Argyle, TXBuilt 1978 · S/N 28-7990239 N2249TKrause Michael B · Camarillo, CABuilt 1979 · S/N 28-7990318 N2249VMystere Flying Club Inc · Little Ferry, NJFirst renewal noticeBuilt 1979 · S/N 28-7990347 N224ELNrcme Training Systems LLC · Breese, ILBuilt 1977 · S/N 28-7716238 N224HSHenderson State University · Arkadelphia, ARBuilt 2007 · S/N 2844131 N224NDGood Flight Aviation LLC · Stockton, CABuilt 2001 · S/N 2842112 N224TBHot Wings Aviation LLC · Indianapolis, INBuilt 2023 · S/N 28020126 N224VUp And Up Aviation LLC · Magnolia, TXS/N 28-7916402 N224VWMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881533 N2250BBill Frank J · Enfield, CTBuilt 1978 · S/N 28-7916122 N2250KKaemmerling Mirna C · White Oak, TXBuilt 1978 · S/N 28-7990240 N225CBCalifornia Baptist University · Riverside, CABuilt 2023 · S/N 2881634 N225FGMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881569 N225KLMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881534 N225RSMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881543 N225TBHot Wings Aviation LLC · Indianapolis, INBuilt 2023 · S/N 28020127

Back to AD 2016-07-21