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.

N761CCHesston College Aviation · Hesston, KSBuilt 1976 · S/N 28-7690288 N7620FRed 5 LLC · Kalispell, MTFirst renewal noticeBuilt 1976 · S/N 28-7790195 N7629FEagle Archer Pilots LLC · Indianapolis, INS/N 28-7790198 N762NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2026 · S/N 28010019 N762SSShetter Steven P · Chambersburg, PABuilt 1978 · S/N 28-7816537 N7637F37 Foxtrot LLC · Mesa, AZBuilt 1976 · S/N 28-7790200 N7644FBel Holdings LLC · Albert Lea, MNBuilt 1976 · S/N 28-7790201 N7645FSagittarius Fox Aviation LLC · San Francisco, CABuilt 1976 · S/N 28-7790202 N7646FShouling & Philip Enterprise · Lancaster, CABuilt 1976 · S/N 28-7790204 N764CCYale Companies LLC DBA Hot Wings Aviation LLC · Fishers, INBuilt 2025 · S/N 2881918 N764NDUniversity Of North Dakota · Grand Forks, NDBuilt 2017 · S/N 2843894 N7653FHyldburg Aviation Inc · Plymouth, MABuilt 1976 · S/N 28-7790205 N765NDUniversity Of North Dakota · Grand Forks, NDBuilt 2017 · S/N 2843895 N7663FBandstra James R · Big Rapids, MIBuilt 1976 · S/N 28-7790209 N7664FSkyfusion II LLC · Atlanta, GABuilt 1976 · S/N 28-7790210 N7667CDoral Aviation LLC · Jefferson Hills, PABuilt 1975 · S/N 28-7690074 N766GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881463 N766LAN766la LLC · Philadelphia, PABuilt 2025 · S/N 28020218 N766NDGfk Wings LLC · Grand Forks, NDBuilt 2017 · S/N 2843896 N7670FAkaya LLC · Sherman Oaks, CABuilt 1976 · S/N 28-7790214 N7679FScott Field Flying Club LLC · Elgin, IABuilt 1976 · S/N 28-7790215 N767LAN767la LLC · Philadelphia, PABuilt 2025 · S/N 28020219 N767NDUniversity Of North Dakota · Grand Forks, NDBuilt 2018 · S/N 2881035 N7680FMag Avionics LLC · Woodlands, TXBuilt 1976 · S/N 28-7790217 N7688FLittle House In The Big Woods LLC · Nashville, INBuilt 1976 · S/N 28-7790219 N7689FRed Arrow Aviation LLC · Santa Teresa, NMS/N 28-7790220 N768AMeridian Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843793 N768NDUniversity Of North Dakota · Grand Forks, NDBuilt 2017 · S/N 2843897 N7690UPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020278 N76957Airplane Flyers LLC · Nixa, MOBuilt 1975 · S/N 28-7690098 N7697FTogether Again LLC · Charlotte, NCBuilt 1976 · S/N 28-7790222 N7698FProfessional Pilot Training · Eagle Lake, TXBuilt 1976 · S/N 28-7790223 N769AMeridian Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843794 N769GMN373hp LLC · Ladera Ranch, CABuilt 2021 · S/N 2881448 N769NDN769nd LLC · Sidney, MTBuilt 2016 · S/N 2843861 N76ADWerner Richard · Syosset, NYBuilt 1975 · S/N 28-7690019 N76DHKarapelou James M · Allentown, PABuilt 1995 · S/N 2843019 N76DMHendrix Aviation Inc · Plantation, FLBuilt 1977 · S/N 28-7890110 N76PFRodriguez Amable Omar · Hialeah, FLBuilt 1982 · S/N 28-8216151 N7702HPaphos Airways LLC · Farmingdale, NYBuilt 2003 · S/N 2843568 N770GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881207 N770NDN770nd LLC · Sidney, MTBuilt 2016 · S/N 2843862 N770PRPuerto Rico International Airline Inc · Santurce, PRBuilt 1978 · S/N 28-7816510 N7714CLuebow Jens · Madison, WIBuilt 1975 · S/N 28-7690078 N771CAChristiansen Aviation LLC · Wilmington, DEBuilt 2024 · S/N 2881739 N771NDUniversity Of North Dakota · Grand Forks, NDBuilt 2018 · S/N 2881036 N771PTPilot Training Center LLC · Miami, FLBuilt 2000 · S/N 2844027 N771RANational Aviation Academy Of Mississippi Inc · Clearwater, FLS/N 2841154 N772CAChristiansen Aviation LLC · Wilmington, DEBuilt 2024 · S/N 2881740 N772FTJazz Air LLC · Melbourne, FLBuilt 2000 · S/N 2844029

Back to AD 2016-07-21