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.

N560ABQuartermaster Growth LLC · Vashon, WABuilt 2007 · S/N 18281947 N560FASteffel Farms LLC · Olivia, MNBuilt 2003 · S/N 172S9560 N560THLe Tourneau University · Longview, TXBuilt 2016 · S/N 172S11668 N561CKTextron Aviation Inc · Wichita, KSS/N 172S13622 N561DAb Prop Plane II LLC · Metairie, LABuilt 2017 · S/N 172S12066 N561FGRidgeline Assets LLC · Wilmington, DEBuilt 2022 · S/N 172S12909 N561MBVital Equipment LLC · Midland, TXBuilt 2004 · S/N 18281425 N561NDSpartan Education LLC · Tulsa, OKBuilt 2011 · S/N 172S11099 N561SAWingsleasing LLC · Wichita, KSBuilt 2004 · S/N 172S9638 N562ABNavigation Leasing LLC · Castle Rock, COS/N 172S9545 N562ACN91934 LLC · Evergreen, COS/N 172S9548 N562AEL-Bird LLC · Hood River, ORBuilt 2003 · S/N 172S9553 N562AFMustang Sally Aviation LLC · Camden, SCBuilt 2003 · S/N 172S9555 N562CBKqm Aviation · Bristow, VABuilt 2010 · S/N 18282207 N562FElite Approach LLC · Chesterfield, MOBuilt 2004 · S/N 172S9664 N562GKAbney Stanley Don · Patterson, LABuilt 2004 · S/N T18208318 N562NDSpartan Education LLC · Tulsa, OKBuilt 2011 · S/N 172S11100 N563EREmbry-Riddle Aeronautical Univerity Inc · Prescott, AZBuilt 2023 · S/N 172S13088 N563FAWang Yuemin · Wauconda, ILBuilt 2003 · S/N 172S9563 N563NDAerosim Academy Inc · Sanford, FLBuilt 2008 · S/N 172S10788 N563SPSloan Joseph · Lancaster, CAS/N 172S8416 N564ATMustang Sally Aviation LLC · Camden, SCBuilt 2005 · S/N 172S10020 N564MCB Air Lc · Sikeston, MOBuilt 2000 · S/N 172S8512 N565ADPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2005 · S/N 172S9991 N565CHTextron Aviation Employees Flying Club Inc · Wichita, KSBuilt 2026 · S/N 172S13493 N565EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2022 · S/N 172S12877 N565NDAerosim Academy Inc · Sanford, FLBuilt 2008 · S/N 172S10797 N565SPLlp Leasing Group LLC · Lewes, DEBuilt 2000 · S/N 172S8489 N5667KSmith John L · Renton, WABuilt 2001 · S/N 172S8991 N566CPCivil Air Patrol · Maxwell Afb, ALBuilt 2018 · S/N 18283033 N566DDeland Aviation LLC · Deland, FLBuilt 2007 · S/N 172S10529 N566EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2022 · S/N 172S12878 N566NDCoast Flight Training And Management Inc · San Diego, CABuilt 2008 · S/N 172S10804 N566SPLlp Leasing Group LLC · Lewes, DEBuilt 2000 · S/N 172S8490 N567AAAoa Kissimmee Inc · Kissimmee, FLBuilt 2014 · S/N 172S11418 N567CPCivil Air Patrol · Maxwell Afb, ALS/N 18282167 N567DDAir America Flight Center LLC · Daytona Beach, FLBuilt 2005 · S/N 172S9971 N567JWKingdom Power And Glory LLC · Colorado Springs, COBuilt 1999 · S/N 172S8187 N567NDMoore Aviation Inc · Beaver Falls, PABuilt 2008 · S/N 172S10805 N567SPAb Prop Plane II LLC · Metairie, LABuilt 2021 · S/N 172S12705 N568CPCivil Air Patrol · Maxwell Afb, ALBuilt 2020 · S/N 18283105 N568MCChristianson Kelly · Lusk, WYBuilt 2001 · S/N T18208010 N568NDAerosim Academy Inc · Sanford, FLBuilt 2008 · S/N 172S10806 N569CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N 18283071 N569DVDelta Victor LLC · Wilmington, DEBuilt 2002 · S/N T18208173 N569FGMustang Sally Aviation LLC · Camden, SCBuilt 2008 · S/N 172S10871 N569NDVertol Systems Co Inc · Destin, FLBuilt 2009 · S/N 172S11004 N569RJNational Training I LLC · Wilmington, DES/N 172S8896 N569SPGlobal Flight Training Solutions Inc · Immokalee, FLBuilt 2000 · S/N 172S8494 N56CWLaurel Aviation Inc · Decatur, ILBuilt 2024 · S/N 18283256

Back to AD 2005-05-53 R1