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.

N9512FGeorge'S Aviation Services Inc · Honolulu, HIBuilt 1998 · S/N 17280429 N9515QVictory Aviation Club Inc · Hamilton, OHBuilt 1998 · S/N 17280383 N9515SKingsky Flight Academy LLC · Lakeland, FLBuilt 1998 · S/N 17280398 N9516JEastern Kentucky University · Richmond, KYBuilt 1998 · S/N 17280396 N951JAAerochatt LLC · Cleveland, TNBuilt 2007 · S/N 172S10496 N951MCSky Mates Inc · Wilmington, DEBuilt 2001 · S/N 172S8951 N951SCJuliet Charlie Aviation LLC · Scottsdale, AZBuilt 2013 · S/N 172S11252 N951SPN591sp LLC A Series Of Aero Lease LLC · San Antonio, TXS/N 172S8151 N951TAKb Land And Cattle Company LLC · Hood River, ORBuilt 2003 · S/N 172S9518 N9520DHodge Flight Services LLC · Pittsburg, CABuilt 1998 · S/N 17280385 N9520WAmeriflyers Of Texas Inc · Addison, TXBuilt 1998 · S/N 17280407 N9520ZK2 Aviation LLC · Greenwood Village, COBuilt 2013 · S/N 172S11278 N9522ADunn Legacy Inc · Saint Petersburg, FLBuilt 1998 · S/N 17280411 N9522SSnohomish Flying Service Inc · Snohomish, WABuilt 1998 · S/N 17280432 N9525VFirst Eclipse Ltd · Richmond, VABuilt 1998 · S/N 17280315 N9526GAtlas Aviation Tampa Inc · Tampa, FLBuilt 1998 · S/N 17280434 N9528WWings Over Texas Holdings LLC · Denton, TXBuilt 1998 · S/N 17280467 N9529WFlight Operations Aircraft LLC · Wilmington, DEBuilt 1998 · S/N 17280470 N952JAHuerta Holdings Inc · Santa Ana, CABuilt 2007 · S/N 172S10474 N952SCMike Charlie Aviation LLC · Scottsdale, AZBuilt 2014 · S/N 172S11406 N9530HHorizon Aircraft Sales & Leasing Inc · Chesapeake, VABuilt 2013 · S/N 172S11295 N95314Menagerie Enterprises Inc · Denison, TXBuilt 2014 · S/N 172S11403 N9531DAtp Aircraft 4 LLC · Wilmington, DEBuilt 1999 · S/N 17280473 N9536DCalifornia Management And Consulting LLC · North Hollywood, CABuilt 1998 · S/N 17280481 N9537QBoeing Empolyees Flying Assn · Renton, WABuilt 1998 · S/N 17280483 N953ACConeburripul Corp · Miami, FLBuilt 1998 · S/N 17280549 N953AFRegistration Pending · Addison, TXRegistration pendingBuilt 2026 · S/N 172S13567 N953RRGig Aviation LLC · Harrisburg, ARBuilt 2007 · S/N 18282009 N9543PHerr Bridget J · Boles, ARBuilt 1999 · S/N 17280644 N9545FEastern Cincinnati Aviation Inc · Batavia, OHBuilt 1998 · S/N 17280380 N9547WWatch Ya Head Aviation I LLC · Zionsville, INBuilt 1998 · S/N 17280508 N9548WZh Aviation LLC · Wilmington, DEBuilt 1999 · S/N 17280512 N9549FJogger Industries LLC · Sherwood, NDBuilt 1998 · S/N 17280514 N954ACAir Future Airways Corp · Miami, FLBuilt 1997 · S/N 17280053 N954FGRidgeline Assets LLC · Wilmington, DEBuilt 2025 · S/N 172S13279 N954JAAdvanced Aviation Group LLC · Frederick, MDS/N 172S10500 N954MGPirolo Michael · Orange, CABuilt 2008 · S/N T18208890 N954MLLakeshore Aviation LLC · Denver, NCBuilt 2024 · S/N T18209149 N9550GCopper Skies Aviation LLC · Mesa, AZBuilt 1998 · S/N 17280516 N9550QDecatur Aero Club Inc · Decatur, ILBuilt 1998 · S/N 17280517 N9550SBald Eagle Enterprises Inc · Nashville, TNBuilt 1999 · S/N 17280758 N9552AAmeriflyers Of Texas Inc · Addison, TXBuilt 1998 · S/N 17280531 N9553ATitusville Aero Club Inc · Titusville, PABuilt 1998 · S/N 17280376 N9559DChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 17280488 N9559SElizabeth Dloda LLC · Hilton Head Island, SCBuilt 1998 · S/N 17280490 N9559VOcm Aviation LLC · Buckeye, AZBuilt 1998 · S/N 17280491 N955ACNaples Air Center Inc · Naples, FLBuilt 2001 · S/N 172S8984 N955CPCivil Air Patrol · Maxwell Afb, ALBuilt 2018 · S/N 172S12157 N955JAAero Equities LLC · Ventura, CABuilt 2007 · S/N 172S10501 N955SPBarto Jerrel C · Kula, HIBuilt 1999 · S/N 172S8155

Back to AD 2005-05-53 R1