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.

N1090VAviation Training LLC · Wilmington, DEBuilt 2006 · S/N 172S10283 N1090WMedary Aviation LLC · Brookings, SDBuilt 2006 · S/N 172S10284 N1092AGulf Coast Aviation LLC · New Orleans, LABuilt 2006 · S/N 172S10286 N1092UBrakke Barak · Clear Lake, IABuilt 2006 · S/N T18208630 N10936Illusion Yacht Charters Inc · Fort Pierce, FLBuilt 2006 · S/N T18208631 N10965Clampitt Darrell · Gray, GABuilt 2007 · S/N 18281976 N1097NSale Reported · Peoria, AZSale reportedBuilt 2005 · S/N 172S9821 N1097YAtlas Aviation Tampa Inc · Tampa, FLBuilt 2006 · S/N 172S10296 N109CQWatkins Eric Brian · San Diego, CABuilt 2016 · S/N 18282462 N109CRBabcock Jimmie J Jr · Bowling Green, KYBuilt 2006 · S/N T18208553 N109DLBoon Aviation LLC · Spring Lake, MIBuilt 2006 · S/N T18208636 N109LULynn University Inc · Boca Raton, FLBuilt 2001 · S/N 17280991 N109TJLanier Equipment Leasing LLC · Gainesville, GABuilt 2001 · S/N 17280985 N10HPAviation Systems And Service LLC · Mounds, OKBuilt 2004 · S/N 18281428 N11019Cc Ventures LLC · Bowling Green, KYBuilt 2006 · S/N 172S10300 N11024Cao Wayne M · Dublin, CABuilt 2000 · S/N 17280913 N1103HSlezak David · Davison, MIBuilt 2006 · S/N T18208637 N1104XFlight Training Aircraft LLC · Wilmington, DEBuilt 2006 · S/N 172S10297 N1105XGay Faith E · Johnstown, NYS/N 18281980 N1107GLunken Flight Training Center LLC · Cincinnati, OHBuilt 2006 · S/N 172S10303 N1108PRay Lee LLC · Cody, WYBuilt 2006 · S/N T18208639 N110GCAltitude Ventures LLC · Lexington, NCBuilt 2019 · S/N 18283062 N110LULynn University Inc · Boca Raton, FLBuilt 2006 · S/N 17281326 N110SQLand Air & Sea LLC · Concord, NCBuilt 2006 · S/N 172S10384 N1117PD W Shimoda LLC · Itasca, ILBuilt 2005 · S/N 18281580 N111AKKershaw Andrew H · Spring, TXBuilt 2025 · S/N 18283325 N111HKSky Peace Aviation LLC · Springdale, ARBuilt 2015 · S/N 18282377 N111WYN111wy LLC · Wilmington, DEBuilt 2002 · S/N T18208144 N1120ZWhite Wing Air LLC · Garden Grove, CAS/N 172S10313 N1122TAircraft Solutions Group LLC · Englewood, COBuilt 2019 · S/N 172S12416 N1125GBlue Knot LLC · Teguesta, FLBuilt 2023 · S/N T18209117 N1127DWings Over Texas Holdings LLC · Denton, TXBuilt 2006 · S/N 172S10247 N1129CLanier Equipment Leasing LLC · Gainesville, GABuilt 2018 · S/N 172S12227 N1129KOrange County Flight Center Inc · Santa Ana, CABuilt 2006 · S/N 172S10315 N1129PBonzo Air LLC · Saint Petersburg, FLBuilt 2005 · S/N 18281584 N112PFEastern Kentucky University · Richmond, KYBuilt 1998 · S/N 17280400 N112PZSkymaxx Inc · Daytona Beach, FLBuilt 2005 · S/N 172S9833 N112SPMinnesota Department Of Public Safety · Saint Paul, MNBuilt 2019 · S/N 18283086 N112SVGb Aviation Of Alabama LLC · Millry, ALBuilt 2003 · S/N 172S9380 N1132WC Flying K Aviation LLC · Savery, WYBuilt 2006 · S/N 172S10125 N1132XWest Coast Equipment Leasing LLC · Englewood, COBuilt 2006 · S/N 172S10316 N1134DFma Auto Sales LLC · Greensboro, NCBuilt 2005 · S/N 18281605 N1137Y412 Jackson Site Development LLC · Oxford, MSBuilt 2005 · S/N 18281602 N113AKFlight Training Aircraft LLC · Wilmington, DEBuilt 2006 · S/N 172S10182 N113HPState Of Ohio · Columbus, OHBuilt 2002 · S/N 18281159 N113PFPremier Flight Center LLC · Hartford, CTBuilt 1998 · S/N 17280401 N113SVChristiansen Aviation LLC · Wilmington, DEBuilt 2003 · S/N 172S9512 N113TLKramer David P · Lebanon, TNBuilt 2003 · S/N T18208219 N11414Van Bortel Aircraft Inc · Arlington, TXBuilt 2005 · S/N T18208413 N1142UCorporacion Dbm LLC · Miami, FLBuilt 2005 · S/N 18281604

Back to AD 2005-05-53 R1