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.

N772NDUniversity Of North Dakota · Grand Forks, NDBuilt 2018 · S/N 2881037 N772VBSkybone Airline Academy Inc · Vero Beach, FLBuilt 2023 · S/N 28020105 N7734CAstillero Ricardo · Northfield, NJS/N 28-7690079 N773FTRatte David R · W Melbourne, FLBuilt 2000 · S/N 2844030 N773GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881221 N773NDUniversity Of North Dakota · Grand Forks, NDBuilt 2018 · S/N 2881038 N7740UPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020279 N774CAChristiansen Aviation LLC · Wilmington, DEBuilt 2024 · S/N 2881763 N774NDUniversity Of North Dakota · Grand Forks, NDBuilt 2018 · S/N 2881042 N7759WGoedecke Chris A · Whitesboro, TXBuilt 1979 · S/N 28-7916411 N775GParagon Flight Training Co · Fort Myers, FLBuilt 2025 · S/N 28020243 N775NDUniversity Of North Dakota · Grand Forks, NDBuilt 2018 · S/N 2881043 N775PPAims Community College · Greeley, COBuilt 2024 · S/N 2881783 N776CAChristiansen Aviation LLC · Wilmington, DEBuilt 2024 · S/N 2881764 N776GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881472 N776NDUniversity Of North Dakota · Grand Forks, NDBuilt 2018 · S/N 2881044 N777CWKeidel Mark T · Redlands, CABuilt 1977 · S/N 28-7890233 N777ESD&J Aviation LLC · Gotha, FLBuilt 1997 · S/N 2843088 N777EZInternational Aviation Group LLC · Lake Wales, FLBuilt 1978 · S/N 28-7916216 N777SDBoomerang Air LLC · Cedar Park, TXBuilt 1980 · S/N 28-8190125 N778NDUniversity Of North Dakota · Grand Forks, NDBuilt 2018 · S/N 2881045 N7793CPaolucci James H · Warwick, RIBuilt 1975 · S/N 28-7690082 N779GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881222 N77EQDuncan Real Estate Investments LLC · Sutherlin, ORS/N 287790101 N77GMMartin Gustavo E · Cooper City, FLBuilt 1976 · S/N 28-7790218 N77LZO'Quinn Debbie M · Jesup, GAS/N 28R-7737073 N77ZBIkiugu Moses · Vermillion, SDS/N 28-7790359 N780FMIolaire Aviation Inc · Wilmington, DEBuilt 2002 · S/N 2844086 N780LAN780la LLC · Philadelphia, PABuilt 2025 · S/N 28020222 N780UOhio University · Albany, OHBuilt 2005 · S/N 2842232 N7815FBrammer Bryon L · Simi Valley, CABuilt 1976 · S/N 28-7790226 N781LAN781la LLC · Philadelphia, PABuilt 2025 · S/N 28020213 N781PAPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010042 N7820CSummit Flight Academy LLC · Peculiar, MOBuilt 1975 · S/N 28-7690083 N7821CArmy Knife Enterprises LLC · Oak Hills, CABuilt 1975 · S/N 28-7690084 N782GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881464 N782LAN782la LLC · Philadelphia, PABuilt 2025 · S/N 28020214 N782MFWallace State Community College · Hanceville, ALBuilt 2023 · S/N 28020122 N783LAN783la LLC · Philadelphia, PABuilt 2025 · S/N 28020215 N7840FLederach David B · Bethlehem, PABuilt 1976 · S/N 28-7790228 N7848CZeitler Christopher · Middleton, WIBuilt 1975 · S/N 28-7690085 N784LAN784la LLC · Philadelphia, PABuilt 2025 · S/N 28020216 N7853CDue West Aviation LLC · Brandon, SDBuilt 1975 · S/N 28-7690086 N785LAN785la LLC · Philadelphia, PABuilt 2025 · S/N 28020217 N785RMJesnet Aviation LLC · Sanford, FLBuilt 1986 · S/N 28-8616057 N786BGGross Kyle F · Salt Lake City, UTBuilt 2006 · S/N 2844126 N786FBEagle Aviation LLC · Indianapolis, INBuilt 2024 · S/N 28020176 N787BGWestchester Flying Club Inc · Purchase, NYBuilt 2002 · S/N 2844085 N787CESouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 28-43336 N787CJInternational Air Services Inc Trustee · Carson City, NVBuilt 2010 · S/N 2843679

Back to AD 2016-07-21