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.

N478KJBw182t LLC · Ocean City, MDBuilt 2021 · S/N 18283140 N478KNKunes Kimberly A · Westport, WABuilt 2023 · S/N 18283227 N478MCDouble Eagle Air LLC · Searcy, ARBuilt 2005 · S/N 18281578 N478SPAbove And Beyond Aviation LLC · Austin, TXBuilt 1998 · S/N 172S8023 N479EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2015 · S/N 172S11601 N479SPRegistered aircraftBuilt 1998 · S/N 172S8024 N47AFL & J Aviation Inc · Atwater, CABuilt 2001 · S/N 17281041 N47GFGlobal Flight Support And Sales Inc · Tampa, FLBuilt 1997 · S/N 17280161 N47KMMyers Boyz Aviation LLC · Horseshoe Bay, TXBuilt 2009 · S/N T18208927 N47TNFlight Operations Aircraft LLC · Wilmington, DEBuilt 2005 · S/N 172S9996 N480ERFlying Off Leash Aviation LLC · Daniel Island, SCBuilt 1998 · S/N 17280624 N480SPDhs Operations LLC · Wilmington, DEBuilt 1998 · S/N 172S8025 N481CPBlue Water Aviation LLC · Oakman, ALBuilt 2008 · S/N 18282048 N481EREmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 2019 · S/N 172S12250 N481TCFargo Aviators LLC · Phoenix, AZBuilt 2002 · S/N T18208184 N481WPoper Jeremy · Albuquerque, NMBuilt 2005 · S/N T18208362 N482CACivil Air Patrol · Maxwell Afb, ALBuilt 2008 · S/N 18282142 N482CGKilo Sierra Enterprises LLC · Lafayette, COBuilt 2005 · S/N T18208438 N482CPCivil Air Patrol · Montgomery, ALBuilt 2010 · S/N 18282263 N482CSTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13482 N482EREmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 2019 · S/N 172S12252 N482SPArq Aviation LLC · Wilmington, NCBuilt 1998 · S/N 172S8028 N482TWT34 Mentor LLC · Saint Joseph, ILBuilt 2017 · S/N 18283006 N4839TOrchard Elms LLC · North Ogden, UTBuilt 2011 · S/N T18209026 N483CACivil Air Patrol · Maxwell Afb, ALBuilt 2025 · S/N T18209172 N483EREmbry Riddle Aeronautical University · Daytona Beach, FLBuilt 2019 · S/N 172S12254 N483SPScandinavian Aviation Academy Inc · El Cajon, CABuilt 1998 · S/N 172S8029 N484CSTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13484 N484ERWisconsin Aviation-Four Lakes Inc · Madison, WIBuilt 2001 · S/N 172S8944 N484HRCebolla Air LLC · Camarillo, CABuilt 2009 · S/N T18208973 N4855PAvenger Aviation LLC · Midland, TXBuilt 2004 · S/N T18208337 N485CACivil Air Patrol · Maxwell Afb, ALBuilt 2025 · S/N 18283301 N485JMSanders Flight Training Center Inc · Jasper, ALBuilt 2025 · S/N 172S13465 N485VL & W Leasing LLC · Smyrna, TNBuilt 1999 · S/N 172S8316 N486CACivil Air Patrol · Maxwell Afb, ALBuilt 2025 · S/N 18283302 N486CPCivil Air Patrol · Montgomery, ALBuilt 2010 · S/N 18282261 N486ERUw Flying Club Inc · Sun Prairie, WIBuilt 1998 · S/N 17280672 N486TCMonte D Burke · Dallas, TXBuilt 2004 · S/N 18281446 N487ERCloudchasers LLC · Colorado Springs, COS/N 172S10547 N487SPArchimedes Aviation LLC · Livermore, CABuilt 2001 · S/N 172S8765 N488EREmbry Riddle Aeronautical University · Daytona Beach, FLBuilt 2019 · S/N 172S12256 N48EFVista Air Inc · Pacoima, CABuilt 2004 · S/N 172S9629 N48FFWingsleasing LLC · Wichita, KSBuilt 2022 · S/N 172S12875 N48RGBlueskies LLC · Smyrna, TNBuilt 2023 · S/N 172S12953 N490CPCivil Air Patrol · Maxwell Afb, ALBuilt 2010 · S/N 18282205 N490EREmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 2019 · S/N 172S12258 N490LLAntel Av Corp · Lewes, DEBuilt 2004 · S/N 18281432 N490NWGalvin Flight Services Hawaii LLC · Honolulu, HIBuilt 2021 · S/N 172S12757 N490SPSky Training LLC · West Milford, NJBuilt 1998 · S/N 172S8031 N491EREmbry Riddle Aeronautical University · Daytona Beach, FLBuilt 2019 · S/N 172S12259

Back to AD 2005-05-53 R1