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.

N597SPViolet Sparkle Pearl LLC · Hanover, NHBuilt 2000 · S/N 172S8525 N597TXCareer Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13229 N598SPFb Aviation LLC · Minot, MEBuilt 2000 · S/N 172S8526 N59EFTancredi Andrew D · Germantown, TNBuilt 2004 · S/N 18281359 N59FFPeregrine Howard Partners II Lp · New Orleans, LABuilt 2023 · S/N 172S12933 N59LJL & J Aviation Inc · Atwater, CABuilt 2001 · S/N 17281043 N59TWAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13249 N6000VTextron Aviation Inc · Wichita, KSS/N 172S13603 N60030Jmj Properties LLC · Atchison, KSBuilt 2006 · S/N T18208500 N6004LJackson Mac Roy Jr · Hood River, ORS/N T18208506 N6004YYyky LLC · Walnut Creek, CABuilt 2006 · S/N T18208509 N60051Compass Rose Aviation LLC · Derby, KSBuilt 2026 · S/N 18283355 N6005JTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 18283353 N6005SCompass Rose Aviation LLC · Derby, KSBuilt 2026 · S/N 18283354 N6009MKd 172 Ventures I LLC · Bellevue, WABuilt 2006 · S/N 172S10134 N6009POh Air LLC · Mentor, OHBuilt 2006 · S/N 172S10137 N6009VMaui Aviators LLC · Pukalani, HIFirst renewal noticeBuilt 2006 · S/N 172S10138 N600PKGetzel Air LLC · Conover, WIBuilt 2008 · S/N 18282082 N6012U6012u LLC · Union Gap, WABuilt 2006 · S/N 172S10168 N6012ZChristiansen Aviation LLC · Wilmington, DEBuilt 2006 · S/N 172S10150 N6013JAerodrome LLC · Louisville, KYBuilt 2006 · S/N 172S10153 N6013KLdm LLC · Cuba, MOBuilt 2006 · S/N 18281795 N6013SStomio LLC · Covina, CABuilt 2006 · S/N 18281797 N6013VFlynn James H Jr · Saratoga Springs, NYBuilt 2006 · S/N 18281798 N60143H2 Link Company · Lewes, DEBuilt 2008 · S/N 172S10142 N6014GBennett Michelle D · Middletown, NJBuilt 2006 · S/N T18208530 N6014JDue West Aviation LLC · Gypsum, COBuilt 2006 · S/N T18208531 N60155Jls Aviation LLC · Sarasota, FLBuilt 2006 · S/N 172S10167 N60166Gabriel/Jordan Holdings Gp Inc · Henderson, TXBuilt 2006 · S/N T18208543 N6016BTnj Adventures LLC · Kalispell, MTBuilt 2006 · S/N T18208539 N6016VTiseo Paul J · Chester, CTBuilt 2006 · S/N T18208541 N6017LAviation Training LLC · Wilmington, DEBuilt 2006 · S/N 172S10170 N6017NGood Dog Leasing LLC · Vienna, VABuilt 2006 · S/N 172S10171 N6018KChristiansen Aviation LLC · Wilmington, DEBuilt 2006 · S/N 172S10174 N6018ZWarner Aviation Co · Council Bluffs, IABuilt 2006 · S/N 172S10175 N6019VChristiansen Aviation LLC · Wilmington, DEBuilt 2006 · S/N 172S10177 N6019XRuegg Charles E · Belfast, MEBuilt 2006 · S/N 18281812 N601LSM&G Aircraft Management LLC · Englewood, COBuilt 2022 · S/N 172S12853 N6020F7l Air LLC · Franklin, TXBuilt 2006 · S/N 18281814 N6020KDuont LLC · Portola Valley, CABuilt 2004 · S/N T18208236 N6020ZTisdale Enterprises LLC · Pensacola, FLS/N T18208545 N6021FB R S Leasing Inc · Wilmington, DEBuilt 2006 · S/N 172S10180 N6021KRegistration Pending · Grand Forks, NDRegistration pendingBuilt 2006 · S/N 172S10181 N6021MPark Rapids Avionics Inc · Park Rapids, MNBuilt 2006 · S/N 18281817 N6022JPavise LLC · Midland, TXBuilt 2006 · S/N T18208550 N6022NStrong Brothers Aviation Inc · Leesburg, FLBuilt 2006 · S/N T18208551 N6023SChristiansen Aviation LLC · Wilmington, DEBuilt 2006 · S/N 17281337 N6023VChristiansen Aviation LLC · Wilmington, DEBuilt 2006 · S/N 172S10198 N6024EDhs Operations LLC · Wilmington, DEBuilt 2006 · S/N 172S10200 N6024TDouglass Bruce · Conway, MABuilt 2006 · S/N 172S10202

Back to AD 2005-05-53 R1