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.

N468CMUniversity Of Central Missouri · Warrensburg, MOBuilt 2000 · S/N 17280860 N468CPTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 18283351 N468EREmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 2021 · S/N 172S12659 N468HN1694l LLC · Wilmington, DEBuilt 2004 · S/N 18281346 N469ERMaxxum Financial Group Inc · Destrehan, LABuilt 2001 · S/N 172S8940 N469FGMustang Sally Aviation LLC · Camden, SCBuilt 2008 · S/N 172S10884 N469MBFloriflt LLC · Daytona Beach, FLBuilt 2005 · S/N 172S9944 N469MHWhat Could Go Wrong LLC · Murfreesboro, TNBuilt 2025 · S/N 18283324 N469TCEast Pole Aviation LLC · E Setauket, NYBuilt 2001 · S/N 18280989 N46EFPringle Dan · Charlestown, INS/N 18280992 N46FFFf22 LLC · Scottsdale, AZBuilt 2022 · S/N 172S12874 N470CACivil Air Patrol · Maxwell Afb, ALBuilt 2025 · S/N T18209171 N470EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2015 · S/N 172S11599 N470KMAv Chase LLC · Kirtland, OHBuilt 1998 · S/N 17280614 N470PGreentree Aviation LLC · Sewell, NJBuilt 2004 · S/N 18281290 N470UNew Horizon Aviation Inc · Warwick, RIBuilt 1998 · S/N 17280415 N471EREmbry Riddle Aeronautical University · Daytona Beach, FLBuilt 2018 · S/N 172S12193 N471MRAdvanced Aviation Group LLC · Frederick, MDS/N 17281078 N471SPPine Ventures LLC · Malmo, NEBuilt 1998 · S/N 172S8014 N471TMAlf Ix LLC · Chicago, ILBuilt 2026 · S/N 172S13471 N472CMUniversity Of Central Missouri · Warrensburg, MOBuilt 2008 · S/N 172S10668 N472DAlf Ix LLC · Chicago, ILBuilt 2017 · S/N 172S12065 N472ELAa-Aero LLC · Lewes, DEBuilt 2026 · S/N 172S13559 N472EREmbry Riddle Aeronautical University · Daytona Beach, FLBuilt 2018 · S/N 172S12194 N472SPAmerican Aviation Inc · Brooksville, FLBuilt 1998 · S/N 172S8017 N472TWSkywest Leasing Inc · St George, UTBuilt 2020 · S/N 172S12517 N472WCJoe Morten & Son Inc · South Sioux City, NEBuilt 2002 · S/N 18281156 N473CAWingsleasing LLC · Wichita, KSS/N 172S11738 N473CMN473cm LLC · Manassas, VABuilt 2006 · S/N 172S10398 N473CSDae Aviation Enterprises Corp · Gilford, NHBuilt 2016 · S/N 172S11673 N473EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2015 · S/N 172S11600 N474CMUniversity Of Central Missouri · Warrenburg, MOBuilt 2008 · S/N 172S10683 N474EPSunshine Holding LLC · Danbury, CTBuilt 1998 · S/N 17280616 N474SMPinnacle Aviation Services Inc · Encinitas, CABuilt 1999 · S/N 172S8280 N474SPJads Aviation LLC · Rowlett, TXS/N 172S8020 N475EREmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 2019 · S/N 172S12248 N476CACivil Air Patrol · Maxwell Afb, ALBuilt 2025 · S/N 18283298 N476CMUniversity Of Central Missouri · Warrensburg, MOBuilt 2015 · S/N 172S11621 N476EREmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 2019 · S/N 172S12249 N476SPChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 17280621 N477EE477ee LLC · Bethany, OKBuilt 2023 · S/N 172S12954 N477GFState Of Alabama Department Of Conservation · Montgomery, ALBuilt 2018 · S/N 18283055 N477GYGolf Yankee LLC · Haymarket, VABuilt 2024 · S/N 18283265 N477LPTomchan LLC · Bostic, NCBuilt 2005 · S/N T18208477 N478ACModern Mobility LLC · Kennedale, TXBuilt 2024 · S/N 18283272 N478CAWingsleasing LLC · Wichita, KSS/N 172S11740 N478CMUniversity Fo Central Missouri · Warrensburg, MOBuilt 2011 · S/N 172S11143 N478FGHazelbaker Tara L · Loxley, ALBuilt 2007 · S/N T18208774 N478GPGypsy Aviation LLC · Hattiesburg, MSBuilt 2005 · S/N 18281523 N478KBoard Of Trustees Of Southern Illinois University · Carbondale, ILBuilt 2023 · S/N 172S12966

Back to AD 2005-05-53 R1