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.

N853PUTrustees Of Purdue University · West Lafayette, INS/N 2881326 N854PUTrustees Of Purdue University · West Lafayette, INS/N 2881327 N855PUTrustees Of Purdue University · West Lafayette, INS/N 2881328 N8569QSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842404 N856PProfessional Training Aircraft LLC · Wilmington, DEBuilt 2018 · S/N 2843944 N856PUTrustees Of Purdue University · West Lafayette, INS/N 2881329 N8570FIxi LLC · West Bloomfield, MIBuilt 1976 · S/N 28-7790258 N8570RSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842405 N8571YSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842406 N8572ZSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842407 N8573JSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842408 N8574KSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842409 N8575WSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842410 N8576XSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842411 N8577YSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842412 N8578CRiver Valley Flyers LLC · West Hartford, CTBuilt 1976 · S/N 28-7690152 N8578ZSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842413 N857GArcher Flight LLC · Wilmington, DEBuilt 2018 · S/N 2881068 N857PUTrustees Of Purdue University · West Lafayette, INS/N 2881330 N857SSjs Aviation Co · Casper, WYBuilt 1981 · S/N 28-8190224 N857SCFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881741 N8580ESkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842414 N8581ASkyborne Airline Academy Inc · Vero Beach, FLBuilt 2024 · S/N 28020159 N8581JSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842415 N8582ESkyborne Airline Academy Inc · Vero Beach, FLBuilt 2024 · S/N 28020160 N8582MSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2016 · S/N 2844160 N8583BSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2024 · S/N 28020201 N8583NSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2016 · S/N 2844161 N8584DSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2025 · S/N 28020202 N8584TSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2016 · S/N 2844162 N8585HSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2025 · S/N 28020232 N8585ZSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2016 · S/N 2844163 N8586ASkyborne Airline Academy Inc · Vero Beach, FLBuilt 2016 · S/N 2844164 N8586JSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2025 · S/N 28020233 N8587KSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2016 · S/N 2844165 N8587LSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2025 · S/N 28020234 N8588PSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2025 · S/N 28020235 N8589SSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2025 · S/N 28020249 N858PUTrustees Of Purdue University · West Lafayette, INS/N 2881331 N858SMLoomer Donald W · Williston, NDBuilt 1982 · S/N 28-8290079 N8590ZSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2025 · S/N 28020250 N8591CSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2026 · S/N 28020256 N8592ERegistration Pending · Vero Beach, FLRegistration pendingBuilt 2026 · S/N 28020257 N8593GPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020274 N8594FPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020275 N8595DPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020276 N859PUTrustees Of Purdue University · West Lafayette, INS/N 2881332 N859SCFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881742 N85NAHampden Aviation Services Inc · Northampton, MAS/N 287816296 N85SPBurkett Jacob E · Polk City, FLBuilt 1976 · S/N 28-7690216

Back to AD 2016-07-21