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.

N696EAHubbard Broadcasting Inc · Saint Paul, MNBuilt 2005 · S/N 18281722 N697CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 172S11562 N698JABon Bon Aviation LLC · Daly City, CABuilt 2008 · S/N 172S10698 N698SPFoothill Aircraaft Sales & Service Inc · Upland, CABuilt 2000 · S/N 172S8639 N699CBBig Skylands Aviation LLC · Succasunna, NJBuilt 2001 · S/N 18281033 N699CPCivil Air Patrol · Maxwell Afb, ALBuilt 2020 · S/N 18283103 N699LPFrg III Inc DBA · Lincoln Park, NJBuilt 1999 · S/N 172S8275 N6HPState Of Ohio · Columbus, OHBuilt 2001 · S/N 18281070 N700PMRar LLC · Louisville, KYBuilt 1998 · S/N 172S8034 N701FASkylane Flyers LLC · Fort Mill, SCBuilt 2002 · S/N 18281107 N701LULiberty University · Lynchburg, VABuilt 2012 · S/N 172S11163 N701SPScandinavian Aviation Academy Inc · El Cajon, CAFirst renewal noticeBuilt 1999 · S/N 172S8192 N702CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281702 N702GRAir America Flight Center LLC · Daytona Beach, FLBuilt 1998 · S/N 17280558 N702LULiberty University · Lynchburg, VABuilt 2014 · S/N 172S11386 N703BFTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13488 N703BKKenzy 2023 LLC · Castle Rock, COBuilt 2023 · S/N 172S12991 N703CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281703 N703CWWasem Investments LLC · Salem, ORBuilt 2005 · S/N T18208464 N703LULiberty University · Lynchburg, VABuilt 2014 · S/N 172S11387 N703WMMoore Tom · Basalt, COBuilt 2005 · S/N T18208461 N704CPTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 18283358 N704LULiberty University · Lynchburg, VABuilt 2014 · S/N 172S11425 N704MCCrowther Construction Inc · Pleasant View, UTBuilt 2004 · S/N T18208251 N704RBAirway Equipment Leasing LLC · Alpharetta, GABuilt 2004 · S/N 172S9657 N705DBEbco Aviation Insurance LLC · New Bern, NCBuilt 2017 · S/N 18282432 N705EFEverett Farr 182 LLC · Lewes, DEBuilt 2025 · S/N 18283300 N705FGRidgeline Assets LLC · Wilmington, DEBuilt 2023 · S/N 172S13073 N705JAFrl Flying LLC · Seattle, WABuilt 2006 · S/N 172S10255 N705LULiberty University · Lynchburg, VABuilt 2014 · S/N 172S11426 N705UChristiansen Aviation LLC · Wilmington, DEBuilt 2021 · S/N 172S12628 N706CPCivil Air Patrol · Maxwell Afb, ALS/N 18281704 N706LULiberty University · Lynchburg, VABuilt 2014 · S/N 172S11472 N706SATextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13576 N707DAProp Flying LLC · Missoula, MTBuilt 2007 · S/N T18208771 N707FSky Magic Aviation Inc Trustee · Wilmington, DES/N 18281081 N707LULiberty University · Lynchburg, VABuilt 2014 · S/N 172S11473 N707PDTfs Air LLC · Loveland, COBuilt 2000 · S/N 172S8389 N708LULiberty University · Lynchburg, VABuilt 2014 · S/N 172S11474 N709CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281709 N709DBPowerhouse Detox Inc · Otis, ORBuilt 2004 · S/N 18281382 N709LULiberty University School Of Aeronautics · Lynchburg, VABuilt 2014 · S/N 172S11419 N70JAN70ja LLC · Stuart, FLBuilt 1998 · S/N 17280660 N70SUOhio State University · Columbus, OHBuilt 1998 · S/N 17280460 N710CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281710 N710GZB & B Readi-Mix LLC · Ruidoso Downs, NMBuilt 2024 · S/N 18283248 N710KVG B Aerial Applications Inc · Slaton, TXS/N T18208291 N710LULiberty University School Of Aeronautics · Lynchburg, VABuilt 2014 · S/N 172S11420 N710SATextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13577 N710SPElite Approach LLC · Chesterfield, MOBuilt 1999 · S/N 172S8106

Back to AD 2005-05-53 R1