Skip to content

AD 2005-05-53 R1

Registered aircraft · 6,035

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.

N203DBSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2024 · S/N T18209130 N203KSMichael Lichtman Inc · Oceanside, CABuilt 2001 · S/N 172S8856 N203SPColorado State Patrol · Denver, COBuilt 2011 · S/N T18209040 N20401Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12519 N2040HAbc Plane LLC · Freeport, TXS/N 18281639 N20412Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12520 N20416Carl L Mccallister Inc · Wilmington, DEBuilt 2005 · S/N 18281642 N20417Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12522 N20422Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12523 N20425Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12524 N2044YPsalm 19:1 Aviation LLC · Annapolis, MDBuilt 2005 · S/N 18281643 N2046KChristiansen Aviation LLC · Wilmington, DEBuilt 2017 · S/N 172S12092 N2047CPropp & Wings LLC · Missoula, MTBuilt 2005 · S/N T18208445 N20489Lone Oak Properties LLC · Flagstaff, AZBuilt 2005 · S/N T18208446 N2049PVan Bortel Aircraft Inc · Arlington, TXBuilt 2005 · S/N T18208448 N20502Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12525 N20505Hickin Barkley E · Kissimmee, FLBuilt 2001 · S/N 18280953 N20519Skyhawk Leasing LLC · Mccordsville, INBuilt 2004 · S/N 172S9576 N2052GJohnson Thomas · Ballico, CABuilt 2020 · S/N 18283098 N2052VBlue Sky Personnel Services LLC · Coushatta, LABuilt 2004 · S/N 172S9583 N20537Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12526 N20549Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12527 N2054SLewis University · Romeoville, ILBuilt 2004 · S/N 17281203 N2054ZRp3 LLC · Boise, IDS/N T18208449 N2055RWnc Aviation LLC · Arden, NCBuilt 2004 · S/N 172S9581 N20564Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12528 N20566Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12530 N2057PBullock Gary · Saint Regis, MTBuilt 2004 · S/N T18208227 N20597Hk Aircraft Leasing LLC · Lititz, PABuilt 2005 · S/N 172S9947 N205FGRidgeline Assets LLC · Wilmington, DEBuilt 2017 · S/N 172S12093 N205HCGulf Coast Aviation LLC · New Orleans, LABuilt 2005 · S/N 172S10003 N2060UJade Air LLC · Lomita, CABuilt 2005 · S/N 172S9952 N2061MN2061m LLC · Augusta, GABuilt 2026 · S/N 18283337 N2063PRegistered aircraftBuilt 2005 · S/N 18281644 N206WEM&B Holdings LLC · Verdi, NVS/N T18208635 N20704Atpce LLC · Wilmington, DES/N 172S12531 N20707Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12562 N20711Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12563 N20727Atpce LLC · Wilmington, DEBuilt 2020 · S/N 172S12577 N20747Above And Beyond Aviation LLC · Austin, TXBuilt 2020 · S/N 172S12578 N20773Smtm Holdings Inc · Wilmington, DEBuilt 2004 · S/N 172S9570 N2077NLilylands Aviation LLC · Redvale, COBuilt 2004 · S/N T18208225 N207CACivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13071 N207CDCheek Gary L · Chandler, AZBuilt 2007 · S/N T18208791 N207PBBernstein Petra M · Salisbury, MDBuilt 2006 · S/N 18281771 N207SFTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13485 N2080QHyperion Enterprises LLC · Warrenton, VABuilt 2005 · S/N T18208450 N20818N20818 LLC · Wilmington, DES/N 172S12579 N2081JWings Over Texas Holdings LLC · Denton, TXS/N 17280995 N2081SPlane Nonsense Inc · Middletown, DEBuilt 2005 · S/N 172S10023

Back to AD 2005-05-53 R1