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.

N860ACAri Ben Aviator Inc · Fort Pierce, FLBuilt 2020 · S/N 2881385 N860PUTrustees Of Purdue University · West Lafayette, INS/N 2881333 N860SCFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881743 N860TCNorth Star Aviation Inc · Mankato, MNBuilt 2016 · S/N 2842417 N860UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2024 · S/N 28020195 N861PProfessional Training Aircraft LLC · Wilmington, DEBuilt 2018 · S/N 2843945 N861PUTrustees Of Purdue University · West Lafayette, INS/N 2881334 N8623EBeach Pilot LLC · Winchester, VABuilt 1976 · S/N 28-7690182 N862JCHrs Equity Consulting LLC · Miami Beach, FLBuilt 2019 · S/N 2881281 N862PUTrustees Of Purdue University · West Lafayette, INS/N 2881335 N862TCAirmax Aviation LLC · Lake Worth, FLBuilt 1977 · S/N 28-7716290 N863PProfessional Training Aircraft LLC · Wilmington, DEBuilt 2018 · S/N 2843946 N863PUTrustees Of Purdue University · West Lafayette, INBuilt 2021 · S/N 2881477 N863SCPeregrine Howard Partners II Lp · New Orleans, LABuilt 2024 · S/N 2881799 N8645ECichocki Matthew R · Oviedo, FLBuilt 1976 · S/N 28-7690183 N8647ESkywest Leasing Inc · St George, UTBuilt 2000 · S/N 2843374 N864PUTrustees Of Purdue University · West Lafayette, INBuilt 2021 · S/N 2881498 N8650EGotta Fly LLC · Manitou Springs, COBuilt 1976 · S/N 28-7690184 N865ACAri Ben Aviator Inc · Fort Pierce, FLS/N 2881386 N865GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881467 N865PUTrustees Of Purdue University · West Lafayette, INBuilt 2021 · S/N 2881490 N8664CArcher 64c LLC · Essex, MABuilt 1976 · S/N 28-7690156 N866PUTrustees Of Purdue University · West Lafayette, INBuilt 2021 · S/N 2881491 N8675EBarbarich Allen G · Las Vegas, NVBuilt 1976 · S/N 28-7690186 N867CTTessos Air Service Inc · Wilmington, DEBuilt 1976 · S/N 28-7790079 N867PProfessional Training Aircraft LLC · Wilmington, DEBuilt 2018 · S/N 2843948 N867PUTrustees Of Purdue University · West Lafayette, INBuilt 2021 · S/N 2881497 N868PProfessional Training Aircraft LLC · Wilmington, DEBuilt 2018 · S/N 2843949 N868UInter American University Of Puerto Rico · Bayamon, PRBuilt 2026 · S/N 28020268 N869BCInter American University Of Puerto Rico · Bayamon, PRBuilt 2026 · S/N 28020269 N869GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881468 N869MAGoose Aviation Co · Farmingdale, NYS/N 28-8316060 N869TASheeptick LLC · Conrad, MTBuilt 2022 · S/N 2881545 N86PFCti Aircraft Leasing LLC · Memphis, TNS/N 2881299 N86SUHeavenly Realms Aviation LLC · Grand Junction, COBuilt 2005 · S/N 2844122 N86TUFosaaen Karl · Albany, ORBuilt 1979 · S/N 28-7916535 N870AMMojo Medical LLC · Webb City, MOBuilt 2004 · S/N 2843604 N870MAMaverick Flight LLC · Dover, DEBuilt 1977 · S/N 28-7790529 N870NDUniversity Of North Dakota · Grand Forks, NDBuilt 2025 · S/N 2881921 N870PAHot Wings Aviation LLC · Indianapolis, INBuilt 2020 · S/N 2881337 N871ACAri Ben Aviator Inc · Fort Pierce, FLBuilt 2020 · S/N 2881387 N871MAN2634mm LLC · Farmingdale, NYBuilt 1979 · S/N 28-7916512 N8723COracle Aviation LLC · Omaha, NEBuilt 1976 · S/N 28-7690159 N872AMBecker Thomas Lee · Arlington, VABuilt 1978 · S/N 28-7890333 N873PAAv8 Flight Assets LLC · Eden Prairie, MNBuilt 2020 · S/N 2881338 N8741EWinters Jesse · New Braunfels, TXBuilt 1976 · S/N 28-7690196 N874ACAri Ben Aviator Inc · Fort Pierce, FLBuilt 2020 · S/N 2881388 N874PAFf22 LLC · Scottsdale, AZS/N 2881339 N8750ECrosscheck Ftc LLC · Greeneville, TNBuilt 1976 · S/N 28-7690197 N8751EHansen William L · Shasta Lake, CABuilt 1976 · S/N 28-7690198

Back to AD 2016-07-21