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.

N983RAChristiansen Aviation LLC · Wilnington, DEBuilt 1997 · S/N 17280097 N983SPBusiness Mens Flying Club Inc · Naperville, ILBuilt 1999 · S/N 172S8185 N983WUEnvoy Air Services LLC · Leipsic, OHBuilt 1998 · S/N 17280498 N9841XHarms Aviation Investments LLC · Wilmington, DEBuilt 2004 · S/N 18281360 N98436Christiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 17280612 N984AVAtp Aircraft 1 LLC · Wilmington, DEBuilt 1998 · S/N 17280576 N984BTMoore Aviation Inc · Beaver Falls, PABuilt 1998 · S/N 17280431 N984CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1997 · S/N 17280233 N984JAKinman Plumbing Co Inc · Louisville, KYBuilt 2007 · S/N 172S10562 N984JSFvx Research · Bristow, VABuilt 2010 · S/N 18282218 N984SPRedstone Arsenal Flying Activity · Redstone Arsenal, ALBuilt 1999 · S/N 172S8188 N984WUMoore Aviation Inc · Beaver Falls, PABuilt 1998 · S/N 17280510 N98510Touch-N-Go Flying Club Inc · Hillsboro, INBuilt 1998 · S/N 17280611 N985BJDon Davis Aviation Inc · Henderson, KYBuilt 2015 · S/N 172S11634 N985CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1997 · S/N 17280235 N986AVMoore Aviation Inc · Beaver Falls, PABuilt 1998 · S/N 17280580 N986BTMoore Aviation Inc · Beaver Falls, PABuilt 1998 · S/N 17280443 N986CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1997 · S/N 17280236 N986DKNbr Aviation · Bristow, VABuilt 2010 · S/N 18282230 N986MTOtv Leasing · Bristow, VABuilt 2010 · S/N 18282217 N986WUSilverhawk Aviation Academy LLC · Caldwell, IDBuilt 1998 · S/N 17280535 N987AVMoore Aviation Inc · Beaver Falls, PABuilt 1998 · S/N 17280585 N987BCWings Over Texas Holdings LLC · Denton, TXBuilt 1998 · S/N 17280471 N987CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1997 · S/N 17280241 N987FAChristiansen Aviation LLC · Wilmington, DEBuilt 2002 · S/N 172S9087 N987PFSun City Aviation LLC · Davie, FLBuilt 2005 · S/N 172S9785 N9886FMoody Bible Institute Of Chicago · Spokane Valley, WABuilt 1997 · S/N 17280151 N988BEN988be LLC · Manassas, VABuilt 2005 · S/N 172S10006 N988BZRauh William · New Hope, PABuilt 2011 · S/N 18282305 N988CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1997 · S/N 17280254 N988WUBravo Whiskey Aviation LLC · Louisville, KYBuilt 1998 · S/N 17280567 N9895FRetro Modern Aviation LLC · Manitou Springs, COBuilt 1997 · S/N 17280179 N9897FPinnacle Aviation Services Inc · Encinitas, CAS/N 17280180 N989CPCivil Air Patrol · Maxwell Afb, ALBuilt 2008 · S/N 18282116 N989SPJet Air Inc · Iowa City, IABuilt 1999 · S/N 172S8210 N989WDTextron Aviation Employees Flying Club Inc · Wichita, KSBuilt 2025 · S/N 172S13289 N989WUEglin Aero Club · Eglin Afb, FLBuilt 1998 · S/N 17280571 N98FFPeregrine Howard Fund V Owner LLC · New Orleans, LABuilt 2024 · S/N 172S13208 N98MLPlr Services LLC · Stuart, FLBuilt 2019 · S/N 18283066 N98VFFitzpatrick Patrick D · Titusville, FLBuilt 2025 · S/N 18283316 N9905FNew Horizon Aviation Inc · Warwick, RIBuilt 1997 · S/N 17280184 N990CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1997 · S/N 17280256 N9918FChristiansen Aviation LLC · Wilmington, DEBuilt 1997 · S/N 17280194 N991WTAmerican Crane Rental Inc · Escalon, CABuilt 2005 · S/N T18208370 N992CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1997 · S/N 17280284 N992VTVermont Flight Academy · South Burlington, VTBuilt 1998 · S/N 172S8043 N992WWTss Flying Club Inc · Bethesda, MDBuilt 1999 · S/N 17280717 N9935FKrahe Richard P · Willoughby, OHBuilt 1999 · S/N 17280645 N993CDDavenport Roustabout Service Inc · Chandler, OKBuilt 2008 · S/N T18208824 N993CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1998 · S/N 17280317

Back to AD 2005-05-53 R1