Registered aircraft · 564

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:79-12-11') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-12-11') 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:79-12-11')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-12-11')
  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:79-12-11')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-12-11')
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.

N1019TAndrew University · Berrien Springs, MIBuilt 2006 · S/N 4496232 N102DHPiper Aircraft Inc · Vero Beach, FLBuilt 2025 · S/N 4496597 N114NXin Han Aviation LLC · Atwater, CABuilt 1979 · S/N 44-7995289 N118ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2000 · S/N 4496034 N120RHAir Puerto Rico Corp · Aguadilla, PRBuilt 1978 · S/N 44-7995118 N1221KAirline Transport Professionals Corp Of USA · Wilmington, DES/N 44-7995295 N123FLPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 4496648 N123TJClover Management Systems Inc · Sanford, FLBuilt 1978 · S/N 44-7995045 N125MGHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2002 · S/N 4496152 N125MLL3 Cts Airline Academy · Sanford, FLBuilt 2019 · S/N 4496480 N126MLL3 Cts Airline Academy · Sanford, FLBuilt 2019 · S/N 4496481 N127ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2000 · S/N 4496035 N128ARGeorge'S Aviation Services Inc · Honolulu, HIBuilt 2005 · S/N 4496218 N128MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2003 · S/N 4496171 N129AGMarsh Equipment LLC · Aurora, ORBuilt 2024 · S/N 4496574 N129MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2003 · S/N 4496172 N130AGWings Over Texas Holdings LLC · Denton, TXBuilt 2024 · S/N 4496578 N130MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2019 · S/N 4496477 N131AGWings Over Texas Holdings LLC · Denton, TXBuilt 2024 · S/N 4496589 N132AGMarsh Equipment LLC · Aurora, ORBuilt 2024 · S/N 4496590 N132DWChristiansen Aviation LLC · Wilmington, DEBuilt 2002 · S/N 4496139 N132MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2022 · S/N 4496540 N134DWAtp Aircraft 1 LLC · Wilmington, DES/N 4496167 N134MLL3 Cts Airline Academy · Sanford, FLBuilt 2019 · S/N 4496483 N134MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2024 · S/N 4496593 N135MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2024 · S/N 4496594 N135UInter American University Of Puerto Rico · Bayamon, PRBuilt 1997 · S/N 4496015 N136DWSun Aircraft Management LLC · Ormond Beach, FLBuilt 2003 · S/N 4496168 N139MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2022 · S/N 4496541 N142LHFarmingdale State University · Farmingdale, NYBuilt 2003 · S/N 4496177 N144RUG&M Aircraft Inc · Wheat Ridge, COBuilt 1979 · S/N 44-7995323 N145WWWings Over Texas Holdings LLC · Denton, TXBuilt 2002 · S/N 4496145 N148TTBoard Of Trustees Western Michigan University · Battle Creek, MIBuilt 2018 · S/N 4496428 N150PFParagon Flight Training Co · Fort Myers, FLBuilt 2022 · S/N 4496545 N156WMFixed Wing Holding Company Inc · Pembroke Pines, FLBuilt 2002 · S/N 4496156 N157WMYale Companies LLC DBA · Indianapolis, INBuilt 2002 · S/N 4496157 N158WUYale Companies LLC DBA · Indianapolis, INBuilt 2002 · S/N 4496158 N159WMFixed Wing Holding Co Inc · Pembroke Pines, FLBuilt 2002 · S/N 4496159 N160PTPilot Training Center LLC · Miami, FLBuilt 1978 · S/N 44-7995161 N162PCBoard Of Trustees Of Western Michigan University · Battle Creek, MIBuilt 2018 · S/N 4496429 N171CAAircraft Parts Store LLC · Jacksonville, FLBuilt 2002 · S/N 4496131 N176CMBoard Of Trustees Of Western Michigan University · Battle Creek, MIBuilt 2018 · S/N 4496427 N180EPPiper Aircraft Inc · Vero Beach, FLS/N 4496656 N186WWWestwind School Of Aeronautics Phoenix LLC · Goodyear, AZBuilt 2004 · S/N 4496186 N187TXXin Han Aviation LLC · Atwater, CABuilt 2001 · S/N 4496099 N190DCHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2001 · S/N 4496103 N191NDMoore Aviation Inc · Beaver Falls, PABuilt 1989 · S/N 4495003 N206ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2000 · S/N 4496036 N2079NSkywarrior Flight Training Inc · Pensacola, FLBuilt 1979 · S/N 44-7995214 N2079WCoast Flight Training And Management Inc · San Diego, CABuilt 1979 · S/N 44-7995270

Back to AD 79-12-11