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.

N622KCAir Burt LLC · Rochester Hills, MIBuilt 2001 · S/N 18281043 N6235TCrystal Air Inc · Chattanooga, TNBuilt 2008 · S/N 17281515 N6236MJlkd LLC · Lewes, DEBuilt 2008 · S/N 18282075 N6238AExecutive Flight Institute LLC · Murrieta, CABuilt 2008 · S/N 172S10702 N623DWHtft LLC · Las Vegas, NVS/N 18281094 N623EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2023 · S/N 172S13097 N623HBRidgeline Assets LLC · Wilmington, DEBuilt 2019 · S/N 172S12397 N623KWLanier Equipment Leasing LLC · Gainesville, GABuilt 2013 · S/N 172S11269 N623RTTextron Aviation Inc · Wichita, KSS/N 18283363 N623SPAtp Aircraft 2 LLC · Wilmington, DEBuilt 2000 · S/N 172S8614 N623UTTextron Aviation Inc · Wichita, KSS/N 18283362 N62404Tech Flyers LLC · Asheville, NCBuilt 2008 · S/N T18208838 N6240JJw2bar Montana LLC · Bozeman, MTBuilt 2008 · S/N T18208837 N6242FAzul Services LLC · Bozeman, MTBuilt 2008 · S/N 172S10701 N6245BInternational Air Services Inc Trustee · Carson City, NVS/N 172S8318 N6245CWings Over Texas Holdings LLC · Denton, TXBuilt 2008 · S/N 172S10723 N6245EDirty Side Down Aviation LLC · Georgetown, TXBuilt 2000 · S/N 172S8674 N6245NRoy Robert William · Cumming, GABuilt 2008 · S/N 18282086 N6245XWarrington Flying Club Inc · Doylestown, PABuilt 2008 · S/N 18282089 N6247CSan Simeon Air LLC · San Francisco, CABuilt 2008 · S/N T18208848 N6248SValiair Limited Company Trustee · Casper, WYBuilt 2008 · S/N T18208849 N624BBravo Aircraft LLC · Alpharetta, GABuilt 2025 · S/N 172S13347 N624CFCorona Jose Jr · Corona, CAS/N 18281059 N624TMKestrel Rentals LLC · Eden, UTS/N T18208244 N6251AKma Air Venture LLC · Fontana, WIBuilt 2008 · S/N T18208852 N6259TRhys Vineyards LLC · Woodside, CABuilt 2008 · S/N T18208853 N625EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2023 · S/N 172S13101 N625HADenventures Aviation LLC · Wheat Ridge, COBuilt 2006 · S/N T18208626 N625LSPhoenix Flyers Inc · Mesa, AZBuilt 2004 · S/N 18281356 N625SPSilverhawk Aviation Academy LLC · Caldwell, IDBuilt 2000 · S/N 172S8616 N62615Chopaire LLC · Decatur, ALBuilt 2008 · S/N T18208854 N6261LWoodward Aviation LLC · Alpine, TXBuilt 2004 · S/N T18208289 N6261RGray Joseph C · San Diego, CABuilt 2004 · S/N T18208290 N6261XLines Gary K · Glendale, AZBuilt 2004 · S/N T18208292 N6265TW Air LLC · Wheeling, ILBuilt 2008 · S/N 172S10733 N6269QMustang Sally Aviation LLC · Camden, SCBuilt 2008 · S/N 172S10715 N626CBWings Over Texas Holdings LLC · Denton, TXBuilt 2008 · S/N 172S10734 N626EPEpic Aviation Inc · Denison, TXBuilt 2026 · S/N 172S13525 N626GMMike Smith Aviation International Inc · Napa, CABuilt 2021 · S/N 172S12688 N626LSHollendonner Keith · Markleville, INBuilt 2005 · S/N T18208405 N626PDC S A Inc · Ogallala, NEBuilt 2006 · S/N T18208547 N62726Xing Kong Aviation Service LLC · Atwater, CAS/N 17281529 N6275SMichigan Dept Of Natural Resources · Roscommon, MIBuilt 2008 · S/N 18282100 N62770Hog Island Flying LLC · Winter Park, FLBuilt 2008 · S/N 172S10747 N6278AJohnstone Jon T · Brentwood, CABuilt 2008 · S/N T18208864 N62799Dutchflier Captial LLC · New Hudson, MIBuilt 2008 · S/N 18282056 N6279AVpc Aviation LLC · Cartersville, GABuilt 2008 · S/N T18208865 N627ARTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13594 N627CTCoast Flight Training And Management Inc · San Diego, CABuilt 2006 · S/N 17281336 N627EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2023 · S/N 172S13063

Back to AD 2005-05-53 R1