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.

N242RBContinental Aerospace Technologies Inc · Mobile, ALBuilt 2011 · S/N 172S11131 N242RDTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 18283334 N242RT9614m Aviation LLC · Boynton Beach, FLS/N 17280537 N242SP242sp LLC · Blaine, MNBuilt 1999 · S/N 172S8226 N242TWTw Airplane LLC · San Antonio, TXBuilt 2005 · S/N 172S9896 N24314Weirich William T Jr · Waterman, ILFirst renewal noticeBuilt 2000 · S/N 17280864 N24318Milo Technologies LLC · Woodstock, GABuilt 2001 · S/N 17280994 N2431XDvirnak Paul · Hesperus, COBuilt 2006 · S/N T18208520 N2432KChristiansen Aviation LLC · Wilmington, DEBuilt 2000 · S/N 17280870 N24334Sorbi Aviation Inc · El Cajon, CABuilt 2000 · S/N 17280887 N24336Moody Bible Institute Of Chicago · Spokane, WABuilt 2000 · S/N 17280888 N2433SN2433s LLC · Manassas, VABuilt 2000 · S/N 17280872 N2433UEddleman David Baggett · Mclean, VABuilt 2001 · S/N T18208006 N24350Aero Equities LLC · Ventura, CABuilt 2006 · S/N 172S10144 N24352National Training I LLC · Wilmington, DEBuilt 2000 · S/N 17280835 N2436NThunderbird Aviation · Bloomington, MNBuilt 2000 · S/N 17280842 N2436VGt Holdings LLC · Nashville, TNBuilt 2006 · S/N 18281786 N2436WThunderbird Aviation · Bloomington, MNFirst renewal noticeBuilt 2000 · S/N 17280841 N2437LLean Enterprises Inc · Brookhaven, MSBuilt 2006 · S/N 18281791 N2438AHorse Creek 3518 Inc · Hollywood, FLBuilt 2006 · S/N 18281793 N2438ERainier Flight Service LLC · Renton, WABuilt 2000 · S/N 17280878 N2438FMackie Scott Christopher · Elkton, MDBuilt 2006 · S/N 18281794 N2438SMid-Island Air Service Inc · Ronkonkoma, NYFirst renewal noticeBuilt 2000 · S/N 17280875 N2439BVan Bortel Aircraft Inc · Arlington, TXBuilt 2001 · S/N 18280955 N2439DN2439d LLC · Oklahoma City, OKBuilt 2006 · S/N T18208525 N2439RAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 2006 · S/N T18208526 N2439SBright Scott Devin · Platteville, COBuilt 2006 · S/N T18208528 N2439ZPlane Nonsense Inc · Middletown, DEBuilt 2007 · S/N 172S10564 N243AURunamuck LLC · New Orleans, LABuilt 2024 · S/N 172S13223 N243CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N 172S12338 N243EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2025 · S/N 172S13281 N243HAAtp Aircraft 8 LLC · Wilmington, DEBuilt 2015 · S/N 172S11583 N243MCRankin John · Nokomis, FLBuilt 2004 · S/N T18208243 N243RLAtp Aircraft 8 LLC · Wilmington, DEBuilt 2015 · S/N 172S11595 N243SPBarbers Point Flight School LLC · Kapolei, HIBuilt 1999 · S/N 172S8212 N2441DKsm Aviation Inc · Wilmington, DEBuilt 2000 · S/N 17280983 N2441EMyf Holdings LLC · San Diego, CABuilt 2000 · S/N 17280879 N2441XPippy LLC · Naples, FLBuilt 2006 · S/N 18281802 N24440Stikes Aviation LLC · Griffin, GABuilt 2001 · S/N 18280956 N24447Mustang Sally Aviation LLC · Camden, SCBuilt 2006 · S/N 172S10122 N2444ETm Pilots LLC · Mc Clelland, IAS/N T18208043 N2444HChristiansen Aviation LLC · Wilmington, DEBuilt 2000 · S/N 17280874 N2445RVan Bortel Aircraft Inc · Arlington, TXBuilt 2005 · S/N 18281720 N2446ZEdb Air Inc · Wilsonville, ORBuilt 2006 · S/N 172S10118 N2447BSilver Express Co · Miami, FLBuilt 1999 · S/N 17280801 N2447DAtp Aircraft 2 LLC · Wilmington, DEBuilt 1999 · S/N 17280803 N2447EWingnut Aviation LLC · Fort Lupton, COS/N T18208767 N24483Fly 172r LLC · Peoria, AZBuilt 2000 · S/N 17280982 N2448BChristiansen Aviation LLC · Wilmington, DEBuilt 2000 · S/N 17280978 N2449TElevation Club Air LLC · Hunting Valley, OHBuilt 2005 · S/N 18281727

Back to AD 2005-05-53 R1