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.

N5860VAlasc Holdings LLC · Albuquerque, NMBuilt 1977 · S/N 28R-7737072 N586KAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843917 N586MAWifa (Washington International Flight Academy) LLC · Gaithersburg, MDBuilt 1999 · S/N 2843297 N5875VCrew Michael A · Phoenix, AZBuilt 1977 · S/N 28-7716209 N5877VWest Keith W · Slatington, PABuilt 1977 · S/N 28-7790505 N5878VVoll Douglas W · Watford City, NDS/N 28-7790506 N587KAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843928 N587MALong Island Aviators LLC · Seaford, NYBuilt 2002 · S/N 2843517 N5882FGo Fly Mi LLC · Saginaw, MIBuilt 1976 · S/N 28-7790140 N5886FBacktoeden LLC · Casper, WYBuilt 1976 · S/N 28-7790141 N5889VJust Plane Fun LLC · Lac Du Flambeau, WIBuilt 1977 · S/N 28-7790507 N588LAPiper 3 LLC · Chestnut Ridge, NYBuilt 2023 · S/N 28020106 N5890VEller Patricia E · Lutz, FLBuilt 1977 · S/N 28-7790508 N5897VMacair Aviation LLC · Xenia, OHBuilt 1977 · S/N 28-7716212 N5898VMaxair Inc · Coxs Creek, KYBuilt 1977 · S/N 28-7716213 N589APa28 Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843765 N589LAPiper 3 LLC · Chestnut Ridge, NYBuilt 2023 · S/N 28020107 N589SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881407 N5900VFagen Aaron J · Granite Falls, MNS/N 28-7790510 N5903VIllinois Valley Flying Club · Peru, ILBuilt 1977 · S/N 28-7790511 N590JKJk Aircraft Options LLC · Aripeka, FLBuilt 2001 · S/N 2844049 N590UOhio University Department Of Aviation · Albany, OHBuilt 2002 · S/N 2844061 N5914VLuvsflying Flight Training LLC · Staten Island, NYBuilt 1977 · S/N 28-7716214 N5917VHeyano Norman J · Dillingham, AKBuilt 1977 · S/N 28-7790512 N5918VKnutson Sever B · Hutchinson, MNBuilt 1977 · S/N 28-7790513 N5926FRegistered aircraftBuilt 1976 · S/N 28-7790143 N592CJAims Community College · Greeley, COBuilt 2019 · S/N 2881183 N592KAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843931 N5932FWingin' It Aviation LLC · Glendale, CABuilt 1976 · S/N 28-7790144 N5932VMacair Aviation LLC · Xenia, OHS/N 28R-7737076 N5934VLuvsflying Flight Training LLC · Staten Island, NYBuilt 1978 · S/N 28-7816603 N5935FBartow Municipal Airport Development Authortiy · Bartow, FLS/N 28-7790145 N593SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881408 N5950KCoco Aircraft Inc · Merritt Island, FLBuilt 1978 · S/N 28-7816585 N5955VWestern Aircraft Solutions · Temecula, CABuilt 1977 · S/N 28-7790516 N5966FHalter George R 3rd · West Chester, PABuilt 1976 · S/N 28-7790146 N596SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881409 N5972FFulhage Eric D · Yates Center, KSBuilt 1976 · S/N 28-7790148 N597AGSkywest Leasing Inc · St George, UTBuilt 2024 · S/N 2881756 N597JFDiamond Travel LLC · Olive Branch, MSBuilt 1977 · S/N 28-7890262 N597JGKnoxville Flyers Inc · Knoxville, TNBuilt 1997 · S/N 2843087 N597SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881410 N598APiper Archer Three LLC · Wilmington, DEBuilt 2014 · S/N 2843767 N598SCSpartan Education LLC · Tulsa, OKBuilt 2020 · S/N 2881411 N5993FGarrett L Gale · Valentine, NES/N 28-7790149 N5997VAero Association Of Caltech Inc · Pasadena, CAS/N 28-7790515 N59ARPiper Aircraft Inc · Vero Beach, FLS/N 28010100 N5BMDja Enterprises LLC · Los Angeles, CABuilt 1979 · S/N 28-8090181 N6004HEngin Aires Aero Club · Savoy, ILS/N 28-7890199 N6008HSwartz Selden H Jr · Jacksonville, ORBuilt 1977 · S/N 28R-7837047

Back to AD 2016-07-21