Skip to content

AD 2005-05-53 R1

Registered aircraft · 6,036

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.

N2118LIasco Flight Training Inc · Redding, CABuilt 1999 · S/N 17280676 N21198Jackie Hood Farms LLC · Moulton, ALBuilt 2005 · S/N 18281647 N2119EMid-Island Air Service Inc · Ronkonkoma, NYBuilt 2004 · S/N 17281212 N2119QMustang Sally Aviation LLC · Camden, SCBuilt 2004 · S/N 172S9623 N211FTUniversity Of The South · Sewanee, TNBuilt 2021 · S/N 172S12774 N211TDChristiansen Aviation LLC · Wilmington, DEBuilt 2000 · S/N 172S8524 N21200Paramus Flying Club Inc · Fairfield, NJBuilt 2005 · S/N 18281732 N21212Sale Reported · Phoenix, AZSale reported, canceledBuilt 2007 · S/N 172S10441 N2121FSouth Dakota State University · Brookings, SDBuilt 2007 · S/N 172S10437 N2121XTaylor Commercial Properties LLC · Jackson, TNBuilt 2004 · S/N 18281480 N2122MHalsted Aviation LLC · West Chicago, ILBuilt 2007 · S/N 172S10442 N2122ZObrien Air LLC · Prescott, AZBuilt 2004 · S/N T18208242 N2123EDream Flights LLC · Brewton, ALBuilt 2004 · S/N 18281331 N2123YPalin Investments 3 LLC · Vancouver, WABuilt 2007 · S/N 18281893 N2125ACable Thomas G · Rockford, MIBuilt 2003 · S/N 18281230 N2125MNfh Aviation LLC · Pikeville, KYBuilt 2000 · S/N 17280905 N21263Suburban Air Corp · Castro Valley, CABuilt 2003 · S/N 172S9429 N2126FVista Aviation Inc · Pacoima, CABuilt 2007 · S/N 172S10458 N21276Schrager Daniel L Trustee · Concord, MABuilt 2003 · S/N 172S9433 N2128YE-Cubed Industries LLC · Big Piney, WYBuilt 2003 · S/N T18208206 N2129CFlot Group LLC · Apex, NCBuilt 2003 · S/N 172S9436 N2129JRidgeline Assets LLC · Wilmington, DEBuilt 2003 · S/N 172S9441 N212BSEuros Aircraft Leasing LLC · College Station, TXBuilt 1999 · S/N 172S8243 N212CFWest Coast Equipment Leasing LLC · Englewood, COBuilt 1998 · S/N 17280418 N2130FSilverhawk Aviation Academy LLC · Caldwell, IDBuilt 2003 · S/N 172S9419 N2131ATru Flight Materials LLC · Wilmington, DEBuilt 2005 · S/N 18281649 N2131UAgh Property Investments Inc · Key West, FLBuilt 2003 · S/N 18281227 N21326Ttf Flying LLC · Anderson, SCBuilt 2007 · S/N 18281897 N2132WWheeler Equipment Leasing LLC · Gainesville, GABuilt 2003 · S/N 172S9421 N21331J-Air Eagle LLC · San Antonio, TXBuilt 2007 · S/N 18281898 N21339Pilots Flying School LLC · Englishtown, NJBuilt 2003 · S/N 172S9551 N2133LGietzen Jeff · Seattle, WABuilt 2003 · S/N 18281287 N2134MChristiansen Aviation LLC · Wilmington, DEBuilt 2003 · S/N 172S9552 N21359Aircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2007 · S/N T18208687 N2135DN2135d LLC · Eustis, FLBuilt 2007 · S/N 18281899 N2135KJet Air Inc · Iowa City, IABuilt 2003 · S/N 172S9556 N2135SEastern Cincinnati Aviation Inc · Batavia, OHBuilt 2003 · S/N 172S9558 N21369Smk Holdings LLC · Sandy, UTBuilt 2003 · S/N 18281292 N2138WChristiansen Aviation LLC · Wilmington, DEBuilt 2003 · S/N 172S9561 N21394Long Island Aviators LLC · Seaford, NYBuilt 2007 · S/N 172S10449 N2139UJust Plane Stuff Inc · Jackson, MSBuilt 2007 · S/N 172S10448 N213AAAir Mac Ventures LLC · Houston, TXBuilt 2007 · S/N 172S10511 N213GGShortcut LLC · Kihei, HIBuilt 2002 · S/N 18281130 N213LPT31 Aviation LLC · Dallas, TXBuilt 2004 · S/N 18281312 N213NBoard Of Trustees Of Southern Illinois University · Murphysboro, ILBuilt 2020 · S/N 172S12572 N21413Botwinick Jeffrey Richard Patrick · Syracuse, NYBuilt 2003 · S/N 18281273 N2141DFoturis Inc · Kingston, PABuilt 2003 · S/N 18281297 N2141YAnson Air LLC · Sugar Land, TXBuilt 2003 · S/N 172S9562 N2142SDbm Farms Inc · Clarksdale, MSBuilt 2003 · S/N T18208224 N2144VAnson Air LLC · Sugar Land, TXBuilt 2003 · S/N 18281276

Back to AD 2005-05-53 R1