Skip to content

AD 2005-05-53 R1

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.

N762CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 172S11576 N762TRWood Eugene H · Hickory, NCBuilt 2001 · S/N 18281004 N763CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 172S11578 N763SPSix Ten Ventures LLC · Grand Prairie, TXBuilt 2001 · S/N 172S8696 N764SPColonial Air Inc · New Bedford, MABuilt 2001 · S/N 172S8697 N765CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N T18208765 N765JMRuppel Willi · Gardnerville, NVBuilt 2006 · S/N T18208576 N765SATextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13580 N766PDTexas State Technical College · Waco, TXBuilt 2000 · S/N 172S8419 N766SHDaystar Aviation LLC · North Canton, OHBuilt 2011 · S/N T18209050 N766SPMaxxum Financial Group Inc · Destrehan, LABuilt 2001 · S/N 172S8699 N767CACivil Air Patrol · Maxwell Afb, ALBuilt 2008 · S/N 18282120 N767CLMls Aviation LLC · Yorba Linda, CABuilt 2005 · S/N 172S9987 N767CRAtp Aircraft 2 LLC · Wilmington, DEBuilt 2005 · S/N 172S10021 N767LRegistered aircraftBuilt 2002 · S/N 18281122 N767RTVan Bortel Aircraft Inc · Arlington, TXBuilt 2023 · S/N T18209107 N767VKTextron Aviation Employees Flying Club Inc · Wichita, KSBuilt 2023 · S/N 172S13021 N767XMNew Landing Aviation LLC · Yonges Island, SCBuilt 2007 · S/N 18282043 N768CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N T18208786 N768CSAircraft Trustee Services Inc Trustee · Dover, DEBuilt 2012 · S/N T18209068 N768SPLast Sea LLC · Saint Augustine, FLBuilt 2001 · S/N 172S8700 N769CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 172S11580 N769CRPromethium LLC · Big Spring, TXBuilt 2023 · S/N T18209109 N769FGMustang Sally Aviation LLC · Camden, SCBuilt 2007 · S/N 172S10584 N769SPWings Over Texas Holdings LLC · Denton, TXBuilt 2001 · S/N 172S8701 N76AERegistered aircraftBuilt 2001 · S/N T18208088 N76FFFf22 LLC · Scottsdale, AZBuilt 2023 · S/N 172S12939 N76UDAlf Ix LLC · Chicago, ILBuilt 2017 · S/N 172S12091 N771CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281781 N771TMMid-South Aviation LLC · Caruthersville, MOBuilt 2011 · S/N 18282286 N772FGRidgeline Assets LLC · Wilmington, DEBuilt 2025 · S/N 172S13277 N772GKAmerican Aircraft Brokers LLC · Aurora, ORBuilt 2005 · S/N 172S9885 N772MSSchmidt Barnet M · Oradell, NJBuilt 1999 · S/N 172S8180 N773AAAlf Ix LLC · Chicago, ILBuilt 2026 · S/N 172S13476 N773BAMustang Sally Aviation LLC · Camden, SCBuilt 2001 · S/N 172S8773 N773SPFox Flying Club Inc · Wheaton, ILBuilt 2001 · S/N 172S8702 N773TFRivergates Ivy Aviation LLC · Boca Raton, FLBuilt 2017 · S/N 18283004 N773TTTim Twisselman Enterprises Inc · San Luis Obispo, CABuilt 2021 · S/N 18283124 N7744SVista Air Inc · Pacoima, CABuilt 1999 · S/N 172S8274 N774CFApperson Aviation LLC · Palm City, FLBuilt 2017 · S/N 18283021 N774CPCivil Air Patrol · Montgomery, ALBuilt 2010 · S/N 18282257 N774LAJaguar Aviation LLC · Hillsboro, ORBuilt 2024 · S/N 172S13117 N774TMVan Bortel Aircraft Inc · Arlington, TXBuilt 2019 · S/N 18283088 N775CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281779 N775DSFlight Ventures LLC · Charlotte, NCS/N T18208498 N775LAColumbia Leasing LLC · Hillsboro, ORBuilt 2024 · S/N 172S13121 N775MRTorres Kim Renee · Castroville, TXS/N 18281073 N775SP775sp LLC · Blaine, MNBuilt 2001 · S/N 172S8705 N776AASolo Aircraft Rental LLC · Farmingdale, NYBuilt 2005 · S/N 172S9928 N776CPCivil Air Patrol · Maxwell Afb, ALBuilt 2006 · S/N 18281776

Back to AD 2005-05-53 R1