Skip to content

AD 2005-05-53 R1

Registered aircraft · 6,036

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.

N2470BAlpha International Aircraft Inc · Lewes, DEBuilt 2005 · S/N 172S10069 N2470NAlpha International Aircraft Inc · Lewes, DENon-citizen corporation, flight hours not reportedS/N 172S10187 N2472UMustang Sally Aviation LLC · Camden, SCBuilt 2005 · S/N 172S10074 N24738H2link Co · Lewes, DEBuilt 2001 · S/N 172S8789 N2473GFly For Fun Aircraft LLC · Baltimore, MDBuilt 2001 · S/N 17281019 N2473ZGulf Coast Aviation LLC · New Orleans, LABuilt 2005 · S/N 172S10082 N24747Peachey Farms LLC · Decatur, IABuilt 2001 · S/N T18208038 N24748Delta State University · Cleveland, MSBuilt 2001 · S/N 17281051 N2474CArchitectural Industrial Rentals LLC · Wilmington, DEBuilt 2001 · S/N 18280978 N2474NWestbank Fishing LLC · Kiln, MSS/N 18280980 N2474VRbj Ranch LLC · Elroy, WIS/N T18208031 N2474YLogan Air Services LLC · Logan, UTBuilt 2005 · S/N 172S10083 N24756Wings Over Texas Holdings LLC · Denton, TXBuilt 2005 · S/N 172S10086 N2475LDeralex Airways LLC · Miami, FLBuilt 2001 · S/N 17280990 N2476ESkyspot Advertising LLC · Lakeland, FLBuilt 2001 · S/N 172S8784 N2476JCrosshares Aircraft Holdings LLC · Plymouth, INBuilt 2001 · S/N 172S8785 N2476XPs N2476x LLC · Green Bay, WIS/N 172S8790 N2476YAmerican Aviation Inc · Brooksville, FLBuilt 2005 · S/N 172S10087 N2477FChristiansen Aviation LLC · Wilmington, DEBuilt 2007 · S/N 172S10574 N2477JAviation Training LLC · Wilmington, DEBuilt 2001 · S/N 172S8802 N24780San Diego Flight Training International Inc · San Diego, CABuilt 2001 · S/N 17281028 N24783Elite Approach LLC · Chesterfield, MOBuilt 2001 · S/N 17281029 N24787W Tech Consulting Inc · Wilmington, DEBuilt 2001 · S/N 172S8804 N2478DAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2007 · S/N T18208775 N2479BPac 2 LLC · Clinton, IABuilt 2001 · S/N 172S8806 N2479MSt Thomas Jet Center Flying Club LLC · Lewes, DES/N 172S10581 N247AUPeregrine Howard Partners II Lp · New Orleans, LABuilt 2024 · S/N 172S13264 N248JWN248jw LLC · Sammamish, WABuilt 2023 · S/N 18283211 N248RAReynolds Darryl G · Wills Point, TXBuilt 2000 · S/N 172S8562 N248SFEl Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 172S13443 N249BKWaggoner Carter · Calera, ALBuilt 2021 · S/N 18283148 N249FSAdvanced Charter & Instruction LLC · Costa Mesa, CABuilt 2005 · S/N 17281249 N249JSCrystal Coast Training LLC · Kinston, NCBuilt 2023 · S/N 172S13011 N249KFf22 LLC · Scottsdale, AZBuilt 2022 · S/N 172S12830 N24AFAbove & Beyond Aviation LLC · Austin, TXBuilt 1998 · S/N 17280439 N24BQAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13217 N24CYAllman Darrell W Jr · Edmond, OKBuilt 2022 · S/N 18283165 N250AUPeregrine Howard Partners II Lp · New Orleans, LABuilt 2024 · S/N 172S13265 N250EWPlane Fun Inc Tr Trustee · Snellville, GABuilt 2020 · S/N 18283106 N250SUOklahoma State University · Stillwater, OKBuilt 2016 · S/N 172S11675 N250YZAtp Aircraft 2 LLC · Wilmington, DEBuilt 2015 · S/N 172S11608 N25110Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13287 N25111Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13290 N25112Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13293 N25113Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13296 N25114Career Track 3 LLC · Wilmington, DEBuilt 2025 · S/N 172S13298 N25115Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13299 N25116Career Track 3 LLC · Wilmington, DEBuilt 2025 · S/N 172S13300 N25118Career Track 4 LLC · Wilmington, DEBuilt 2025 · S/N 172S13302 N25121Career Track 3 LLC · Wilmington, DEBuilt 2025 · S/N 172S13306

Back to AD 2005-05-53 R1