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.

N56GUIdagus N56gu LLC · Miami, FLBuilt 2022 · S/N 18283208 N56LUService Oriented Aviation Readiness S.O.A.R. · Bolivar, MOBuilt 2016 · S/N 172S11727 N570DBAtlas Aviation Tampa Inc · Tampa, FLBuilt 2005 · S/N 18281570 N570FGRidgeline Assets LLC · Wilmington, DEBuilt 2025 · S/N 172S13455 N570JAJ A Flight Services LLC · Sugar Grove, ILBuilt 2007 · S/N 172S10575 N570NDAerosim Academy Inc · Sanford, FLBuilt 2009 · S/N 172S10847 N570SPOne Seventy To Delta LLC · Scottsdale, AZBuilt 2000 · S/N 172S8495 N571BWBridgewater State University · Bridgewater, MABuilt 2004 · S/N 172S9738 N571CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 172S13251 N571DTHardy Donald K · Beach, NDBuilt 2002 · S/N T18208120 N571JAJa Flight Services LLC · Sugar Grove, ILBuilt 2007 · S/N 172S10549 N571MCThompson Gary R · Discovery Bay, CABuilt 2001 · S/N 18281038 N571NDVertol Systems Co Inc · Destin, FLBuilt 2009 · S/N 172S10853 N571SPChristiansen Aviation LLC · Wilmington, DEBuilt 2000 · S/N 172S8496 N572BWBridgewater State University · Bridgewater, MABuilt 2003 · S/N 172S9426 N572JAJ.A. Flight Services LLC · Sugar Grove, ILBuilt 2007 · S/N 172S10553 N572NDAerosim Academy Inc · Sanford, FLBuilt 2009 · S/N 172S10940 N572SPOld Friend Air LLC · Junction City, ORBuilt 2000 · S/N 172S8498 N573KKTextron Aviation Inc · Wichita, KSS/N 18283370 N573NDAir Shares LLC · Casper, WYBuilt 2009 · S/N 172S10941 N574BWBridge State University · Bridgewater, MABuilt 2000 · S/N 17280948 N574CACivil Air Patrol · Maxwell Afb, ALBuilt 2008 · S/N 18282121 N574NDSunrise Aviation Inc · Ormond Beach, FLBuilt 2009 · S/N 172S10943 N575DKTextron Aviation Employees Flying Club Inc · Wichita, KSBuilt 2025 · S/N 18283291 N575NDAir Shares LLC · Casper, WYBuilt 2009 · S/N 172S10954 N575PPHenderson Joseph H · Greenville, SCBuilt 2008 · S/N T18208886 N575SPCharlie Leasing LLC · Green Bay, WIBuilt 2000 · S/N 172S8504 N575YSilverhawk Aviation Academy LLC · Caldwell, IDBuilt 2004 · S/N 172S9656 N576BWBridgewater State University · North Dartmouth, MAS/N 17280494 N576CACivil Air Patrol · Montgomery, ALBuilt 2008 · S/N 18282122 N576DSLcb Leasing · Bristow, VABuilt 2010 · S/N 18282229 N576NDAerosim Academy Inc · Sanford, FLBuilt 2009 · S/N 172S10962 N576SPSo Cal Leasing LLC · El Cajon, CABuilt 2000 · S/N 172S8501 N577AUBeck Patrick · Algonquin, ILBuilt 2015 · S/N 18282370 N577EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2023 · S/N 172S13091 N577FAN577fa LLC · Redondo Beach, CABuilt 2004 · S/N 172S9577 N577FGRidgeline Assets LLC · Wilmington, DEBuilt 2023 · S/N 172S13079 N577NDAir Shares LLC · Casper, WYBuilt 2010 · S/N 172S10986 N577SPTexas State Technical College · Waco, TXBuilt 2000 · S/N 172S8503 N577TZWestbank Fishing LLC · Kiln, MSBuilt 2002 · S/N 18281123 N578BWBridgewater State University · Bridgewater, MABuilt 1998 · S/N 17280522 N578CAChristiansen Aviation LLC · Wilmington, DEBuilt 2008 · S/N 172S10807 N578EREmbry Riddle Aeronautical University Inc · Prescott, AZS/N 172S13094 N578FGTextron Aviation Inc · Wichita, KSS/N 172S13642 N578MCChristiansen Aviation LLC · Wilmington, DEBuilt 2004 · S/N 172S9578 N579BWBridgewater State University · Bridgewater, MABuilt 2000 · S/N 17280944 N579CPCivil Air Patrol · Maxwell Afb, ALBuilt 2020 · S/N 18283101 N579ER22 H20 LLC · Montgomery, TXBuilt 2005 · S/N 18281599 N579WGTrede 2021 C172 LLC · Aurora, ORBuilt 2021 · S/N 172S12752 N57CSSparkjoy Backcountry LLC · Boulder, COBuilt 2025 · S/N 18283295

Back to AD 2005-05-53 R1