Skip to content

AD 2005-05-53 R1

Registered aircraft · 6,034

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.

N1664CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11757 N1668CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11758 N166CPAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2004 · S/N T18208319 N166CSAtp Aircraft 7 LLC · Wilmington, DEBuilt 2016 · S/N 172S11664 N166PAMacmillan Performance LLC · Torrance, CABuilt 2012 · S/N T18209060 N1671CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11759 N1672CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11760 N1673CCe-172 Aircraft LLC · Wilmington, DEBuilt 2012 · S/N 172S11761 N1674EMedary Aviation LLC · Brookings, SDBuilt 2005 · S/N 172S9915 N1676CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11762 N16789Smith Stephen · Annandale, VABuilt 2005 · S/N 172S9916 N1678CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11763 N167CPCivil Air Patrol · Maxwell Afb, ALBuilt 2020 · S/N 172S12500 N167LPSymanowski Kevin L · Reeder, NDBuilt 2001 · S/N 18281067 N167SJAbove And Beyond Aviation LLC · Austin, TXBuilt 1997 · S/N 17280167 N167UDLima 001 LLC · Muscatine, IABuilt 2003 · S/N 17281188 N1683CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11764 N1684ZPetty Venture Investment LLC · Scottsdale, AZBuilt 2007 · S/N T18208757 N1687CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11731 N1688CAerosim Academy Inc · Sanford, FLBuilt 2007 · S/N 172S10612 N1688LHeavy Metal Air LLC · Farmingdale, NYS/N 172S10613 N16894Saz Dynamics LLC · Daly City, CABuilt 2007 · S/N 172S10615 N16895Luxair LLC · College Station, TXBuilt 2007 · S/N 172S10618 N168CACivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13068 N168CBLogan Air Services LLC · Logan, UTBuilt 2002 · S/N 172S9119 N168CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282336 N168DKOtv Leasing · Greenville, DEBuilt 2012 · S/N 18282351 N168TAKj Aviation Holdings LLC · Chesterfield, MIBuilt 2001 · S/N 18281068 N168TCVan Bortel Aircraft Inc · Arlington, TXBuilt 2002 · S/N 18281066 N168YMewmew Investment II LLC · Palo Alto, CABuilt 2021 · S/N 172S12653 N1690LBas Part Sales LLC · Greeley, COBuilt 2007 · S/N 172S10620 N16917Degraffenreid Ronald A · Shawnee, OKBuilt 2007 · S/N T18208803 N1692LSheldon Steven R · Las Vegas, NVBuilt 2007 · S/N T18208804 N1699LBorrero Marien Manuel · Carolina, PRBuilt 2007 · S/N 18282008 N169CBGiuffre Vi LLC · Milwaukee, WIBuilt 2002 · S/N 172S9247 N169CPCivil Air Patrol · Maxwell Afb, ALBuilt 2009 · S/N 18282172 N169LPLcc East LLC · Freehold, NJBuilt 1999 · S/N 172S8234 N169MECc Aviation Inc · Tracy, CABuilt 2000 · S/N 172S8449 N169PXXing Kong Aviation Service LLC · Atwater, CAS/N 17281404 N16GHGreysky LLC · Smyrna, TNBuilt 2026 · S/N 172S13519 N16VLDaro Associates LLC · Mahwah, NJBuilt 2005 · S/N T18208392 N17011Saunders Aviation LLC · South Portland, MEBuilt 2007 · S/N 18282010 N1709TBartolomei Thomas J · Flower Mound, TXBuilt 2005 · S/N 18281619 N170CACivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13070 N170RBChristiansen Aviation LLC · Wilmington, DES/N 172S11130 N1710GNational Test Pilot School · Mojave, CAS/N 18282011 N1710KCareer Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13178 N1712SNorth Carolina Dept Of Enviroment & Natural Resour · Raleigh, NCBuilt 2005 · S/N 18281620 N1713CAir-Spacers Inc · Santa Monica, CABuilt 2007 · S/N 18282013 N1714TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12050

Back to AD 2005-05-53 R1