Registered aircraft · 6,038

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

N641NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2015 · S/N 172S11615 N641SPRhode Island Air LLC · Providence, RIS/N 172S8049 N641THN641th Corp · La Quinta, CABuilt 2021 · S/N 172S12641 N642KMNick Heir LLC · Lexington, KYFirst renewal noticeBuilt 2005 · S/N 172S10053 N642NDPelican Flight Training LLC · San Carlos, CABuilt 2015 · S/N 172S11616 N642SPBlue Sky Aviation Association Inc · Readington, NJBuilt 1998 · S/N 172S8050 N642THFairmont State University · Fairmont, WVBuilt 2021 · S/N 172S12642 N643CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N 18283073 N643GWFoxtrot93 Holdings LLC · Wilmington, DEBuilt 2023 · S/N 18283216 N643PEColiseum Aviation LLC · Little Rock, ARBuilt 2004 · S/N 18281343 N643SPRegistered aircraftBuilt 1998 · S/N 172S8051 N644CPCivil Air Patrol · Maxwell Afb, ALBuilt 2010 · S/N 18282247 N645EPChristiansen Aviation LLC · Wilmington, DEBuilt 2015 · S/N 172S11611 N645FCFlorida Dept Of Agriculure & Consumer Services · Tallahassee, FLBuilt 2021 · S/N 18283152 N645PAzul Services LLC · Bozeman, MTBuilt 2000 · S/N 172S8510 N645PD150th Aero Flying Club · Morristown, NJBuilt 2000 · S/N 172S8644 N645SPRegistration Pending · Bennett, CORegistration pendingBuilt 1998 · S/N 172S8052 N645XAzul Services LLC · Bozeman, MTBuilt 2008 · S/N 172S10692 N645ZAzul Services LLC · Bozeman, MTBuilt 2009 · S/N 172S10928 N64657Elite Approach LLC · Chesterfield, MOBuilt 2004 · S/N 172S9687 N646CBJeffery & Weiss Holdings LLC · Long Beach, CABuilt 2019 · S/N 172S12262 N646DWChristiansen Aviation LLC · Wilmington, DEBuilt 2006 · S/N 172S10141 N646FCFlorida Dept Of Agriculture And Consumer Services · Tallahassee, FLBuilt 2023 · S/N 18283246 N646SPVermeylen Donna Lynn · Altamont, TNBuilt 1998 · S/N 172S8053 N647CRChristiansen Aviation LLC · Wilmington, DEBuilt 2015 · S/N 172S11613 N647CSTextron Aviation Inc · Wichita, KSS/N 172S13647 N647SPElizabeth City State University · Elizabeth City, NCBuilt 1998 · S/N 172S8054 N647THChristiansen Aviation LLC · Wilmington, DEBuilt 2021 · S/N 172S12647 N648CPCivil Air Patrol · Maxwell Afb, ALBuilt 2021 · S/N 172S12624 N648SPHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1998 · S/N 172S8055 N6492GState Of North Carolina · Raleigh, NCBuilt 2004 · S/N 18281411 N649CPCivil Air Patrol · Maxwell Afb, ALBuilt 2011 · S/N 18282282 N649TCSpartan Education Group LLC · Tulsa, OKBuilt 2000 · S/N 172S8649 N64AFVermont Flight Academy · South Burlington, VTBuilt 1997 · S/N 17280069 N64JAJet Air Inc · Iowa City, IABuilt 2001 · S/N 17281065 N64PWM&G Aircraft Management LLC · Aurora, ORBuilt 2024 · S/N 172S13212 N64WGM&G Aircraft Management LLC · Aurora, ORBuilt 2021 · S/N 172S12753 N64WTTietmeyer Scott W · Grover, COBuilt 2006 · S/N T18208590 N650TMSouthwest Construction & Property Management Inc · S San Fran, CABuilt 2006 · S/N T18208650 N651EREmbry-Riddle Aernautical University Inc · Prescott, AZBuilt 2023 · S/N 172S13085 N651MAPea-Wayman Flight LLC · Daytona Beach, FLBuilt 2000 · S/N 17280897 N651PASmn Investments Inc · Greeneville, TNBuilt 2017 · S/N 172S12016 N652171434 Jpl LLC · Wilmington, DEBuilt 2004 · S/N 18281415 N65225Leon Manuel Perez · Lake Worth, FLBuilt 2004 · S/N 18281414 N65234Moore Tommy Vance · Monahans, TXBuilt 2004 · S/N T18208301 N65236Taylor Jonathan P · Danbury, CTBuilt 2004 · S/N 18281417 N652515280 Flying Club LLC · Castle Pines, COBuilt 2004 · S/N 172S9690 N65279Ferrara Joseph Vincent · Port Saint Lucie, FLBuilt 2004 · S/N 18281488 N65290So Cal Leasing LLC · El Cajon, CABuilt 2004 · S/N 172S9693 N652CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N T18208652

Back to AD 2005-05-53 R1