Registered aircraft · 5,458

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.

N140FCDepartment Of Agriculture & Consumer Services · Tallahassee, FLBuilt 1982 · S/N 28-8290175 N140NDCoco Aircraft Inc · Merritt Island, FLBuilt 1989 · S/N 2841206 N1412HAsherbranner Charles E · Yucaipa, CAS/N 28R-7737003 N141AVMavity Michael D · Phoenix, AZBuilt 1984 · S/N 28-8490107 N141FCDepartment Of Agriculture & Consumer Services · Tallahassee, FLBuilt 2019 · S/N 2881158 N141FQCross Daniel · Windham, NHS/N 28-8290176 N141WAJohnston James E · Fernandina Beach, FLBuilt 1980 · S/N 28-8116135 N142FCDepartment Of Agriculture & Consumer Services · Tallahassee, FLBuilt 1982 · S/N 28-8290177 N142NDSkyblue Aviation Cr Inc · Merritt Island, FLBuilt 1989 · S/N 2841229 N143FCDepartment Of Agriculture & Consumer Services · Tallahassee, FLBuilt 1982 · S/N 28-8290178 N1440UPiper Aircraft Inc · Vero Beach, FLBuilt 2025 · S/N 28020248 N144AMStardust Aviation LLC · Farmingdale, NYBuilt 2021 · S/N 28020016 N144CTCti Aircraft Leasing LLC · Memphis, TNS/N 2881298 N145ARPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010047 N145LYQuarter To Two Flying Club Inc · Williamsport, PABuilt 2000 · S/N 28-43335 N1461HJohnson Kent W · Clemons, IAS/N 28-7790313 N146PTCoco Aircraft Inc · Merritt Island, FLBuilt 1979 · S/N 28-7916307 N147GArcher Aero LLC · Wilmington, DEBuilt 2019 · S/N 2881111 N147LHSchool Board Of Brevard County Florida · Melbourne, FLBuilt 2003 · S/N 2844103 N1486HLynn John · Coffee Creek, MTS/N 28-7716026 N1488HDeplazes Anthony · Rugby, NDS/N 28-7716027 N148AParagon Flight Training Co · Fort Myers, FLBuilt 2025 · S/N 28020203 N148FCDepartment Of Agriculture & Consumer Scvs · Tallahassee, FLBuilt 2022 · S/N 2881520 N148KMRstl LLC · Minster, OHS/N 28-7990342 N148LHFarmingdale State University · Farmingdale, NYBuilt 2003 · S/N 2842191 N1490HKoepke Jeffrey J · Waterford, WIS/N 28-7790316 N1490WTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1976 · S/N 28-7690282 N149DTNew Mexico Flying Eagle Inc DBA · Tucson, AZBuilt 2005 · S/N 2844125 N149LHFarmingdale State University · Farmingdale, NYBuilt 2003 · S/N 2842192 N14DJJ&N Management Inc · Wilmington, DEBuilt 2001 · S/N 2843497 N14YBKate Air LLC · Southlake, TXBuilt 1979 · S/N 28-7990461 N150LHFarmingdale State University · Farmingdale, NYBuilt 2003 · S/N 2842193 N151AV51st Aero Squadron LLC · Hoover, ALBuilt 1985 · S/N 28-8590042 N151CHGharazeddine Raja · Kaplan, LABuilt 2001 · S/N 2843495 N151DLBd Aviation LLC · Sauget, ILBuilt 2021 · S/N 28020040 N151GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881456 N151LHFarmingdale State University · Farmingdale, NYBuilt 2003 · S/N 2842194 N152ARPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010048 N152DCTms Aviation LLC · Massapequa, NYBuilt 2001 · S/N 2842140 N152LHFarmingdale State University · Farmingdale, NYBuilt 2003 · S/N 2842195 N153LHFarmingdale State University · Farmingdale, NYBuilt 2003 · S/N 2842196 N154ARPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010049 N154AVDaviation Inc · Willoughby, OHBuilt 1985 · S/N 28-8616018 N154ERN154er LLC · Kissimmee, FLBuilt 1989 · S/N 2841182 N154FTMiloud Chadd K · Fort Worth, TXS/N 28-8216194 N154PAParagon Airplane Leasing Co · Fort Myers, FLBuilt 2020 · S/N 28020012 N155APSpace Coast Aircraft Co · Merritt Island, FLBuilt 1998 · S/N 2842027 N155ARPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010050 N155LHFarmingdale State University · Farmingdale, NYBuilt 2003 · S/N 2842197 N156EWSkyblue Aviation Cr Inc · Merritt Island, FLBuilt 1998 · S/N 2842028

Back to AD 2016-07-21