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.

N288SCDelta Aviation LLC · Oregon City, ORBuilt 2024 · S/N 172S13240 N289CLCripps Jason · Mcminnville, TNBuilt 2023 · S/N 18283241 N289CSChow Rogers LLC · Fort Myers, FLBuilt 2011 · S/N 18282289 N289JSJet Air Inc · Iowa City, IABuilt 2001 · S/N 172S8996 N28EBCohen David A · Charlotte, VTS/N T18208032 N28MKAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13269 N28PKAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13253 N290CPCivil Air Patrol · Maxwell Afb, ALBuilt 2025 · S/N 18283321 N290FGTextron Aviation Inc · Wichita, KSS/N 172S13638 N290PEPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2022 · S/N 172S12864 N290RMCxairco LLC · Yuma, AZBuilt 2010 · S/N 18282215 N290TWChristiansen Aviation LLC · Wilmington, DEBuilt 2001 · S/N 172S9020 N290UOhio University · Albany, OHBuilt 2000 · S/N 172S8551 N291ECElizabeth City State University · Elizabeth City, NCBuilt 2021 · S/N 172S12646 N291FRCon Air Aviation LLC · Borger, TXS/N T18209082 N291HWMiddle Village Enterprises LLC · Maspeth, NYBuilt 2012 · S/N 172S11239 N291JDDahapov LLC · Boca Raton, FLBuilt 2012 · S/N 18282322 N291MEUnique Educational Experiences · Long Beach, CABuilt 2000 · S/N 172S8550 N291PEPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2022 · S/N 172S12865 N291TFTextron Aviation Inc · Wichita, KSS/N 172S13609 N292CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281992 N292CSStature Aviation LLC · Addison, TXBuilt 2025 · S/N 18283292 N292EDL1 Aviation LLC · Sparks, NVBuilt 2002 · S/N 172S9105 N292PEPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2022 · S/N 172S12866 N292SPMonmouth Aircraft Service Inc · Toms River, NJBuilt 2003 · S/N 172S9477 N292TCRich Daniel W · Norton, MABuilt 2002 · S/N 172S9122 N292TFTextron Aviation Inc · Wichita, KSS/N 172S13610 N292VFTextron Aviation Employees Flying Club Inc · Wichita, KSBuilt 2025 · S/N 172S13349 N2931HAtp Aircraft 7 LLC · Wilmington, DEBuilt 2006 · S/N 172S10400 N293CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281993 N293PEPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2022 · S/N 172S12869 N293SPNiemeyer Leasing LLC · Cave Creek, AZBuilt 2003 · S/N 172S9478 N293TFTextron Aviation Inc · Wichita, KSS/N 172S13612 N294CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281994 N294CSState Of Wisconsin Department Of Administration · Madison, WIBuilt 2011 · S/N 18282294 N294EMClover Park Technical College · Lakewood, WABuilt 2026 · S/N 172S13557 N294PEPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2022 · S/N 172S12870 N294PLAerospring Leasing LLC DBA · Wasilla, AKBuilt 2023 · S/N 172S13017 N294RWAb Prop Plane II LLC · Metairie, LABuilt 2022 · S/N 172S12898 N294SPMazurek Harold Wayne · Sidney, TXBuilt 2003 · S/N 172S9479 N294TFTextron Aviation Inc · Wichita, KSS/N 172S13619 N295LPWildridge Aviation LLC · Layton, UTBuilt 2003 · S/N 172S9295 N295MEWings Air Charter LLC · Wisconsin Rapids, WIBuilt 2000 · S/N 172S8553 N295PEPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2022 · S/N 172S12871 N295PLAerospring Leasing LLC DBA · Wasilla, AKBuilt 2023 · S/N 172S13018 N295TFTextron Aviation Inc · Wichita, KSS/N 172S13621 N296CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281995 N296MEJwl Aviation LLC · San Carlos, CABuilt 2000 · S/N 172S8554 N296NWNorthwestern Michigan College · Traverse City, MIBuilt 2011 · S/N 172S11096 N296PEPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2006 · S/N 172S10211

Back to AD 2005-05-53 R1