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.

N541KSKent State University · Stow, OHBuilt 2016 · S/N 172S11671 N541LCBarbers Point Flight School LLC · Kapolei, HIBuilt 2022 · S/N 172S12860 N541WSFox Leasing Group LLC · Hollywood, FLBuilt 2003 · S/N 172S9340 N5421SAmeriflyers Of Texas Inc · Addison, TXBuilt 1999 · S/N 172S8080 N542CPCivil Air Patrol · Maxwell Afb, ALBuilt 2011 · S/N T18209033 N542ECWang Warner Weihsu · Vienna, WVBuilt 2005 · S/N 18281691 N542EREmbry Riddle Aeronautical University Inc · Prescott, AZBuilt 2022 · S/N 172S12872 N542KSKent State University · Stow, OHBuilt 2025 · S/N 172S13367 N542THNorthern Cowboy Holdings LLC · Prior Lake, MNBuilt 2019 · S/N 172S12253 N543EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2025 · S/N 172S13314 N543NDN543nd LLC · Manassas, VABuilt 2010 · S/N 172S10985 N543THRidgeline Assets LLC · Wilmington, DEBuilt 2019 · S/N 172S12255 N544EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2025 · S/N 172S13318 N544KGDawson Aircraft Inc · Clinton, ARS/N T18209006 N544KSKent State University · Stow, OHBuilt 2026 · S/N 172S13510 N544SPSilverhawk Aviation Academy LLC · Caldwell, IDS/N 172S8399 N545FCatching Freedom LLC · Bozeman, MTS/N 172S12357 N545KSKent State University · Stow, OHBuilt 2026 · S/N 172S13512 N545NDChristiansen Aviation LLC · Wilmington, DEBuilt 2008 · S/N 172S10857 N545QCatching Freedom LLC · Bozeman, MTS/N 172S12371 N545UCatching Freedom LLC · Bozeman, MTS/N 172S12311 N545YCatching Freedom LLC · Bozeman, MTS/N 172S12327 N545ZDornoch Services LLC · Dover, DEBuilt 2008 · S/N 172S10770 N546ASouthern Illinois University · Murphysboro, ILBuilt 2011 · S/N 17281594 N546EREmbry Riddle Aeronautical University Inc · Prescott, AZBuilt 2026 · S/N 172S13538 N546KWard Mark E · Brookfield, WIBuilt 2001 · S/N 18281013 N546MCLeaseair LLC · Wilmington, DEBuilt 2000 · S/N 172S8376 N546NDSpartan Education LLC · Tulsa, OKBuilt 2010 · S/N 172S11045 N547CSForever Dream LLC · Wilmington, DEBuilt 2019 · S/N 18283084 N547ESouthern Illinois University · Murphysboro, ILBuilt 2011 · S/N 17281596 N547EREmbry Riddle Aeronautical University Inc · Prescott, AZBuilt 2026 · S/N 172S13541 N547MChapman Joseph Quinn · Seminole, FLBuilt 2022 · S/N 18283167 N547NDSpartan Education LLC · Tulsa, OKBuilt 2010 · S/N 172S11049 N548ASouthern Illinois University · Murphysboro, ILBuilt 2011 · S/N 17281597 N548EPGulf Coast Aviation LLC · New Orleans, LABuilt 2007 · S/N 172S10530 N548EREmbry Riddle Aeronautical University Inc · Prescott, AZBuilt 2026 · S/N 172S13544 N548NDAerosim Academy Inc · Sanford, FLBuilt 2010 · S/N 172S11050 N548RGosnell Christopher Carter · Magnolia, ARBuilt 2005 · S/N 18281576 N548SPMinter Barry · Rockport, MOBuilt 2000 · S/N 172S8401 N5491JChristiansen Aviation LLC · Wilmington, DEBuilt 2006 · S/N 172S10395 N549ASouthern Illinois University · Murphysboro, ILBuilt 2011 · S/N 17281598 N549EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2026 · S/N 172S13547 N549NDSpartan Education LLC · Tulsa, OKBuilt 2010 · S/N 172S11051 N54JASan Carlos Flight Center Inc · San Carlos, CABuilt 1998 · S/N 17280607 N54KPScheuers Alan · Murfreesboro, TNBuilt 2005 · S/N 18281542 N54LULetourneau University · Longview, TXBuilt 2017 · S/N 172S12062 N550ERCoco Aircraft Inc · Merritt Island, FLBuilt 2007 · S/N 172S10531 N550LAOscar Tango LLC · Mesa, AZBuilt 2017 · S/N 172S12045 N550NDPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2009 · S/N 172S10992 N5518GChristiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11391

Back to AD 2005-05-53 R1