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.

N385RBNational Aircraft Leasing Corp · Greenville, DEBuilt 2009 · S/N 18282199 N385TCLiebl Holdings LLC · Claremore, OKS/N T18208385 N386CPCivil Air Patrol · Maxwell Afb, ALBuilt 2026 · S/N 18283344 N386EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2022 · S/N 172S12912 N386ESJet Air Inc · Iowa City, IABuilt 1997 · S/N 17280106 N386MEHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2000 · S/N 172S8583 N386SPUsaf Academy Aero Club · Usaf Academy, COBuilt 1999 · S/N 172S8283 N387AFCsa Aircraft Leasing LLC · Salt Lake City, UTBuilt 2006 · S/N 172S10387 N387CSDa Aviation LLC · Englewood, COBuilt 2011 · S/N 18282287 N387DCDyncorp International Inc · Mcclellan, CABuilt 2021 · S/N 172S12652 N387MAAzul Services LLC · Bozeman, MTBuilt 1998 · S/N 17280387 N387SPMsb Aviation LLC · Rockvale, TNBuilt 1999 · S/N 172S8284 N387TCBass Joel W · Okeechobee, FLBuilt 2005 · S/N T18208386 N389CPCivil Air Patrol · Maxwell Afb, ALBuilt 2020 · S/N 172S12521 N389HMHausmann Aero LLC · Grand Forks, NDBuilt 2007 · S/N T18208693 N38ALAirloc LLC · Atlanta, GABuilt 2004 · S/N 18281450 N38BGCary Aviation LLC · Myrtle Beach, SCS/N 18281334 N38PCLake Day Ventures LLC · Missoula, MTS/N T18209089 N38PDRichmond Pilots Corp · Linden, NJBuilt 2000 · S/N 172S8381 N38RAAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13272 N38SBAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13261 N38USUnited States Aviation Underwriters Inc · New York, NYBuilt 2002 · S/N 18281173 N38WRCds Worldwide Consultants Pllc · Birmingham, MIBuilt 2012 · S/N T18209058 N391SPN391sp LLC A Series Of Aero Lease LLC · San Antonio, TXBuilt 1999 · S/N 172S8286 N392CVBreen James J · Alpharetta, GABuilt 2016 · S/N 18282465 N392EREmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 2023 · S/N 172S12998 N393CA2050 Services LLC · Burlington, WIBuilt 2001 · S/N 172S8983 N393ESLanier Equipment Leasing LLC · Gainesville, GABuilt 1997 · S/N 17280138 N393SPCirrus Aviation · Sarasota, FLBuilt 1999 · S/N 172S8290 N394CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 172S13103 N394CVBas Part Sales LLC · Greeley, COBuilt 2016 · S/N 18282437 N394SPEdb Air Inc · Wilsonville, ORBuilt 1999 · S/N 172S8291 N395CVCivil Air Patrol · Maxwell Afb, ALBuilt 2016 · S/N 18282434 N395SPTexas State Technical College · Waco, TXBuilt 1999 · S/N 172S8292 N396CVCivil Air Patrol · Maxwell Afb, ALBuilt 2016 · S/N 18282435 N396MCJf Aviation LLC · Minot, NDBuilt 2005 · S/N T18208396 N396SPFritz Daniel G · Lodi, CABuilt 1999 · S/N 172S8293 N396TAMonterey Bay Aviation Inc · Watsonville, CAFirst renewal noticeBuilt 2003 · S/N 172S9396 N397CACivil Air Patrol · Maxwell Afb, ALBuilt 2008 · S/N 18282118 N397CPCivil Air Patrol · Maxwell Afb, ALBuilt 2009 · S/N 18282189 N397CVCivil Air Patrol · Maxwell Afb, ALBuilt 2016 · S/N 18282438 N397ESN397es Holding LLC · Palm City, FLBuilt 1997 · S/N 17280164 N397MWMccann Shawn Edward · Newton, NJBuilt 2005 · S/N T18208397 N398CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281998 N398CVCivil Air Patrol · Maxwell Afb, ALBuilt 2016 · S/N 18282436 N398ESChristiansen Aviation LLC · Wilmington, DEBuilt 1997 · S/N 17280156 N399AAAoa Kissimmee Inc · Kissimmee, FLBuilt 2015 · S/N 172S11553 N399CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281999 N399CVCivil Air Patrol · Maxwell Afb, ALBuilt 2016 · S/N 18282441 N399ESBray Aviation LLC · Calera, OKBuilt 1997 · S/N 17280155

Back to AD 2005-05-53 R1