Skip to content

AD 2005-05-53 R1

Registered aircraft · 6,034

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.

N1143XTj Allen Bulk Services LLC · Newport, NYBuilt 2006 · S/N T18208648 N1145BKampton William Charles · Napa, CABuilt 2006 · S/N T18208649 N114FBFly Appleton LLC · Appleton, WIBuilt 2005 · S/N 172S9811 N114TLLa Soplaera Realty LLC · Niwot, COBuilt 2003 · S/N T18208220 N114VKKennedy Virgil C DBA · San Marcos, TXBuilt 2001 · S/N 172S8695 N1152ZRainier Flight Service LLC · Renton, WABuilt 2006 · S/N 172S10339 N1154GPlane Nonsense Inc · Middletown, DEBuilt 2006 · S/N 172S10126 N1154WAerosim Academy Inc · Sanford, FLBuilt 2007 · S/N 172S10608 N1157RSale Reported · Miami, FLSale reportedBuilt 1998 · S/N 17280627 N1158QN1158q LLC · Palm City, FLBuilt 2006 · S/N 172S10354 N1158VAtp Aircraft 7 LLC · Wilmington, DEBuilt 2006 · S/N 172S10355 N1159KCavu Aero LLC · Marietta, GABuilt 2006 · S/N 172S10357 N1159ZThunderfighter LLC · Englewood, COBuilt 2006 · S/N 172S10362 N115BRJp Air LLC · Rockledge, FLBuilt 2016 · S/N 18282415 N115CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N 172S12330 N115FJFargo Jet Center LLC · Fargo, NDBuilt 2008 · S/N 172S10784 N115KSKent State University · Stow, OHBuilt 1999 · S/N 17280819 N115LWCrest Airpark Inc · Kent, WABuilt 2005 · S/N 172S9868 N115SV115sv LLC · Lamar, MOBuilt 2004 · S/N 172S9663 N115TAAtp Aircraft 7 LLC · Wilmington, DEBuilt 2018 · S/N 172S12145 N11614Lewis University · Romeoville, ILBuilt 2006 · S/N 172S10360 N1162UHamel Raymond F Jr · Wellesley, MABuilt 2007 · S/N 18281984 N1164JTyson Bradley · Sherrills Ford, NCBuilt 2023 · S/N 18283240 N1166WFlight Operations Aircraft LLC · Wilmington, DEBuilt 2006 · S/N 172S10363 N11682Jahawk Leasing LLC · Sugar Grove, ILBuilt 2006 · S/N 172S10365 N116CPCivil Air Patrol · Maxwell Afb, ALBuilt 2017 · S/N 18283012 N116DRegistration Pending · Reese, MIRegistration pendingBuilt 2022 · S/N 18283203 N116JEAtp Aircraft 6 LLC · Wilmington, DEBuilt 2018 · S/N 172S12167 N116KSKent State University · Stow, OHBuilt 1999 · S/N 17280820 N116SLXcel Aviation LLC · Eagle, IDBuilt 2003 · S/N 18281242 N116SMArchie Aero LLC · Beaverton, ORBuilt 2005 · S/N T18208426 N116WETextron Aviation Inc · Wichita, KSS/N 172S13611 N1171JNational Test Pilot School · Mojave, CABuilt 2007 · S/N 18281985 N1173XWnc Aviation LLC · Arden, NCBuilt 2006 · S/N 172S10379 N1174CGeorgia Forestry Commission · Macon, GABuilt 2007 · S/N 18281905 N1174HGeremia Frank · Rocklin, CABuilt 2002 · S/N 18281145 N1175KOkmok Aviation LLC · Anchorage, AKBuilt 2007 · S/N T18208690 N1176AJar Air LLC · Incline Village, NVBuilt 2007 · S/N T18208673 N1176RBas Part Sales LLC · Greeley, COBuilt 2005 · S/N 18281688 N1176TP C O Leasing Inc · Dobbin, TXBuilt 2005 · S/N 18281587 N117APAutumn Horizons LLC · Redwood City, CABuilt 2009 · S/N T18208915 N117BDHall Alan Ray · Willow Park, TXBuilt 2017 · S/N 18283024 N117KSKent State University · Stow, OHBuilt 1999 · S/N 17280821 N117SVFlight Operations Aircraft LLC · Wilmington, DEBuilt 2005 · S/N 172S10073 N11802N11802 LLC · Bradenton, FLBuilt 2007 · S/N 172S10463 N1180NWinkelmann Aerospace LLC · Malabar, FLBuilt 2007 · S/N 172S10461 N1182DDura-Built Of Delaware LLC · Lewes, DEBuilt 2025 · S/N T18209183 N1183MHess Darren Michael · Wenatchee, WABuilt 2007 · S/N 18281911 N1184NErickson Holdings LLC · Atlanta, GABuilt 2007 · S/N T18208696 N1186TMap Aviation LLC · Coral Gables, FLBuilt 2007 · S/N 18281879

Back to AD 2005-05-53 R1