Skip to content

AD 2005-05-53 R1

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.

N974BCL & W Aircraft Investment LLC · Homestead, FLBuilt 1997 · S/N 17280044 N974DBPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2008 · S/N 172S10661 N974SPTexas State Technical College · Waco, TXBuilt 1999 · S/N 172S8178 N974TASky Peak Aviation LLC · Los Angeles, CABuilt 2002 · S/N 172S9074 N974THRidgeline Assets LLC · Wilmington, DEBuilt 2023 · S/N 172S12974 N9754FFirst Eclipse Ltd · Richmond, VABuilt 1997 · S/N 17280037 N975CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281975 N975TAMitchell David G · Cadiz, OHBuilt 2002 · S/N 172S9257 N975THAnson Air LLC · Sugar Land, TXBuilt 2023 · S/N 172S12975 N9764FFixed Wing Holding Co Inc · Pembroke Pines, FLBuilt 1997 · S/N 17280042 N9767FMid Island Air Service Inc · Ronkonkoma, NYBuilt 1997 · S/N 17280066 N976CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281996 N977THHeavy Metal Air LLC · Farmingdale, NYBuilt 2023 · S/N 172S12977 N978APAviation Leasing Company LLC · Ooltewah, TNBuilt 2008 · S/N 172S10710 N978CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1997 · S/N 17280209 N978FASky Training LLC · West Milford, NJBuilt 2002 · S/N 172S9078 N978KWOrtega Aviation Services LLC · Wichita, KSBuilt 2011 · S/N 18282278 N978SAMarine Tech One LLC · Dover, DEBuilt 2002 · S/N 172S9178 N978SPLlp Leasing Group LLC · Lewes, DEBuilt 1999 · S/N 172S8181 N9791FRedstone Arsenal Flying Activity · Redstone Arsenal, ALBuilt 1997 · S/N 17280062 N979BCMacinnis Charles E · Harbor Springs, MIBuilt 1997 · S/N 17280060 N979BVTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13490 N979CPCivil Air Patrol Inc · Maxwell Fb, ALBuilt 1997 · S/N 17280210 N979EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2023 · S/N 172S13019 N979SFMaus Stephen N · Bozeman, MTBuilt 2004 · S/N T18208286 N979WDDolphin Leasing LLC · Daytona Beach, FLBuilt 2005 · S/N 172S10077 N97ATRainier Flight Service LLC · Renton, WABuilt 2005 · S/N 172S9853 N97FFPeregrine Howard Fund V Owner LLC · New Orleans, LABuilt 2024 · S/N 172S13207 N97HYFulghum Michael Eugene · Humble, TXBuilt 2004 · S/N 18281349 N97LFSpengler Raymond Francis Jr · Longview, TXBuilt 1997 · S/N 17280286 N97PDBoeing Employees Flying Association Inc · Renton, WABuilt 2000 · S/N 172S8392 N97VACamps Bay Aviation LLC · Waukegan, ILBuilt 2005 · S/N 172S9906 N980CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1997 · S/N 17280213 N980SPFisher Stables And Arena Inc · Gladewater, TXBuilt 1999 · S/N 172S8182 N981BCSilverhawk Aviation Academy LLC · Caldwell, IDBuilt 1998 · S/N 17280464 N981BTPea-Wayman Flight LLC · Daytona Beach, FLBuilt 1998 · S/N 17280430 N981CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1997 · S/N 17280215 N981DRCorder David · Corona De Tucson, AZBuilt 2026 · S/N T18209201 N981MRJlove LLC · Vienna, VABuilt 2010 · S/N 18282212 N981SFAtp Aircraft 1 LLC · Wilmington, DEBuilt 2013 · S/N 172S11293 N981SPLlp Leasing Group LLC · Lewes, DEBuilt 1999 · S/N 172S8183 N981TCPeterson Timothy J · Watertown, SDBuilt 2023 · S/N T18209123 N981TWKent Mark · Holden, MABuilt 2002 · S/N 172S9081 N981WUEastern Kentucky University · Richmond, KYBuilt 1998 · S/N 17280555 N982BTWings Over Texas Holdings LLC · Denton, TXBuilt 1997 · S/N 17280307 N982CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1997 · S/N 17280227 N982SPScott Kenneth C · Erie, COBuilt 1999 · S/N 172S8184 N983CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1997 · S/N 17280228 N983FAFreedom Aviation Inc · Lynchburg, VABuilt 2009 · S/N 172S11009 N983JAGulf Coast Aviation LLC · New Orleans, LABuilt 2007 · S/N 172S10556

Back to AD 2005-05-53 R1