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.

N225FAMcclure Nicholas W · Midland, TXBuilt 2003 · S/N 18281252 N225RARochester Air Center LLC · Canandaigua, NYBuilt 2005 · S/N 172S9803 N225SFAb Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 172S13441 N225TFTop Flight Aviation Inc · Corona, CABuilt 2004 · S/N 172S9755 N225WCBozeman Skyhawk LLC · Bozeman, MTBuilt 2006 · S/N 172S10272 N225WSSpartan Education LLC · Tulsa, OKBuilt 2005 · S/N 172S9800 N2260EJm-Bac Holdings LLC · Arcadia, OKBuilt 2007 · S/N 18281939 N2265WStratus Aviation LLC · Fergus Falls, MNS/N T18208720 N22669R S Bowen Enterprises LLC · Flowery Branch, GABuilt 2007 · S/N 18281942 N2266KFelix Ken Allen · Rye, COBuilt 2007 · S/N T18208721 N2268AAerofeather Aviation Inc · Suffolk, VABuilt 1998 · S/N 17280686 N226AVN286sa LLC · Manassas, VABuilt 2007 · S/N 172S10651 N226CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282345 N226EPEpic Aviation Inc · Denison, TXBuilt 2026 · S/N 172S13513 N226JWThompson Edward Allen · Sunset Beach, NCBuilt 2004 · S/N T18208330 N226SMSarahmaura Aviation Inc · Wayne, NJS/N 18281153 N226TMWadeberg LLC · San Francisco, CABuilt 2007 · S/N T18208796 N2270GNorris Edgar L Jr · Charlotte, NCBuilt 2007 · S/N T18208726 N2270QSure Aviation LLC · North East, MDBuilt 2007 · S/N T18208728 N2272CBartow Municipal Airport Development Authority · Bartow, FLBuilt 2005 · S/N 172S9954 N2272VGryffin Ventures LLC · Jupiter, FLBuilt 2000 · S/N 17280839 N2274BAon-Adharc Aircraft Leasing LLC · Sellersburg, INBuilt 1999 · S/N 17280689 N22761Kop Aviation LLC · El Paso, TXBuilt 2007 · S/N T18208734 N2277TEngisys Traffic LLC · North Potomac, MDBuilt 2005 · S/N 172S9958 N2278YWplanec LLC · Gig Harbor, WABuilt 2007 · S/N T18208736 N227BHPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2008 · S/N 172S10662 N227BSLec Aviation LLC · Winter Garden, FLBuilt 2007 · S/N 18281943 N227CPCivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13049 N227TFTop Flight Aviation Inc · Corona, CABuilt 2006 · S/N 18281826 N227TWChristiansen Aviation LLC · Wilmington, DEBuilt 2002 · S/N 172S9227 N227WCHuerta Holdings Inc · Woodland Hills, CABuilt 2005 · S/N 172S9844 N227WFTrayler James · Waco, TXBuilt 2004 · S/N T18208288 N22801Career Pilot Training LLC · Wilmington, DEBuilt 2022 · S/N 172S12906 N22803Career Pilot Training LLC · Wilmington, DEBuilt 2022 · S/N 172S12908 N22806Career Pilot Training LLC · Wilmington, DEBuilt 2022 · S/N 172S12911 N22807Career Pilot Training LLC · Wilmington, DEBuilt 2022 · S/N 172S12914 N22808Career Pilot Training LLC · Wilmington, DEBuilt 2022 · S/N 172S12915 N22809Career Pilot Training LLC · Wilmington, DEBuilt 2022 · S/N 172S12919 N22810Career Pilot Training LLC · Wilmington, DEBuilt 2022 · S/N 172S12921 N22813Career Pilot Training LLC · Wilmington, DEBuilt 2022 · S/N 172S12924 N22816Career Pilot Training LLC · Wilmington, DEBuilt 2022 · S/N 172S12925 N22818Career Pilot Training LLC · Wilmington, DEBuilt 2022 · S/N 172S12929 N228AZCiaglia Caesar Earle · Mokena, ILBuilt 2009 · S/N T18208969 N228TWNorth Delta Aviation LLC · Blytheville, ARBuilt 2002 · S/N 172S9228 N22904Phoenix East Aviation LLC · Daytona Beach, FLS/N 172S9961 N2290AOrtega Aviation Services LLC · Wichita, KSBuilt 2005 · S/N 172S9959 N2291CForty Four Fifteen LLC · Reno, NVBuilt 2005 · S/N 172S9962 N2291SRegistered aircraftBuilt 2007 · S/N T18208738 N22952Winging It LLC · Lindon, UTBuilt 2007 · S/N T18208740 N2296NMacsdea LLC · Van Nuys, CABuilt 2005 · S/N 172S9967

Back to AD 2005-05-53 R1