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.

N53KCDm Asset Management LLC · Plain City, OHBuilt 1978 · S/N 28-7990032 N5407FFly Quest Aviation LLC · La Verne, CABuilt 1977 · S/N 28-7790112 N5409FBlackwolfden Aviation LLC · Belgrade, MTS/N 28-7790114 N540CWCentral Washington University · Ellensburg, WABuilt 2018 · S/N 2881049 N540PULeo S Anton · Aliso Viejo, CABuilt 2003 · S/N 2844096 N540UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2024 · S/N 28020164 N5419FJfl Aviation LLC · Big Rock, ILBuilt 1976 · S/N 28-7790117 N541CAVaughan Aviation LLC · Azle, TXBuilt 1976 · S/N 28-7790089 N541CWCentral Washington University · Ellensburg, WABuilt 2018 · S/N 2881050 N541PUEquipment Maintenance Specialists LLC · Auxvasse, MOBuilt 2003 · S/N 2844097 N5428FSchold Maury W · Stafford Springs, CTBuilt 1977 · S/N 28-7790118 N5429FQuick Kenneth C Jr · Burke, VABuilt 1976 · S/N 28-7790119 N542APa28 Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843762 N542CWCentral Washington University · Ellensburg, WABuilt 2018 · S/N 2881051 N542KAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843866 N542MADaystar Aviation LLC · Orange Park, FLS/N 28-7816364 N542PUNewbridge Unlimited LLC · Sunny Isles Beach, FLBuilt 2003 · S/N 2844099 N5430FUnion Aviation LLC · El Dorado, ARBuilt 1976 · S/N 28-7790120 N543CWCentral Washington University · Ellensburg, WABuilt 2018 · S/N 2881052 N543PUByc Trucking Services LLC DBA · Norco, CABuilt 2003 · S/N 2844100 N5448FSanford Christopher Evan · Dallas, TXBuilt 1976 · S/N 28-7790124 N5449FEngel Rodney · New Prague, MNBuilt 1976 · S/N 28-7790125 N544CWCentral Washington University · Ellensburg, WABuilt 2018 · S/N 2881053 N544NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2026 · S/N 28010013 N544SWCatherine Michaels Investment Services LLC · Carlsbad, CABuilt 2000 · S/N 2843388 N5450FN5450f LLC · Fernandina Beach, FLBuilt 1976 · S/N 28-7790126 N545CWCentral Washington University · Ellensburg, WABuilt 2018 · S/N 2881054 N545MASkywest Leasing Inc · St George, UTBuilt 2017 · S/N 2843865 N546BNavigation Leasing LLC · Castle Rock, COBuilt 2019 · S/N 2881105 N546CACoast Flight Training And Management Inc · San Diego, CABuilt 2019 · S/N 2881279 N546CWCentral Washington University · Ellensburg, WABuilt 2019 · S/N 2881104 N547CWCentral Washington University · Ellensburg, WABuilt 2020 · S/N 2881383 N547KAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843867 N547SCSpartan Education LLC · Tulsa, OKS/N 2881322 N548CWCentral Washington University · Ellensburg, WABuilt 2020 · S/N 2881384 N548SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881340 N5499FIndy Air Sales LLC · Anderson, INS/N 28-7790127 N549SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881341 N54DLMorris Samuel A · Prineville, ORBuilt 1976 · S/N 28-7690213 N54TXBail Air LLC · Port Saint Lucie, FLBuilt 1977 · S/N 28-7890151 N5504GRemoteguard Services LLC · Wildwood, MOS/N 28-8290068 N5506FShen Air II Inc · Mount Crawford, VAS/N 28-7790128 N550PUSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2000 · S/N 2842106 N5513VRenaldo Michael T · Stafford, VABuilt 1977 · S/N 28-7716181 N551BBMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881574 N551CCYale Companies LLC DBA · Indianapolis, INBuilt 2021 · S/N 2881513 N551PUSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2000 · S/N 2842088 N5520VDouble M Farms LLC · Walsh, COS/N 28-7790479 N5521VAllen Aviation LLC · Leesport, PAS/N 28-7790480 N5525VFlying Particles Inc · Livermore, CAS/N 28-7790481

Back to AD 2016-07-21