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.

N719THAuburn University · Auburn, ALBuilt 2017 · S/N 172S12010 N71BTriplett Gregory S · Groveland, CABuilt 2003 · S/N 18281289 N71CEMcgowan Chad · Rock Hill, SCBuilt 2004 · S/N T18208278 N71DPDjp Enterprises Inc · Chandler, TXBuilt 2001 · S/N T18208056 N71FCNaples Flying Club Inc · Naples, FLBuilt 1997 · S/N 17280237 N71FFFf22 LLC · Scottsdale, AZBuilt 2023 · S/N 172S12935 N71HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2004 · S/N 172S9758 N71HTAerodynamic LLC · Aurora, ORBuilt 2002 · S/N 172S9047 N720CAAero Equities LLC · Oxnard, CABuilt 2026 · S/N 172S13528 N720CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 172S11564 N720LULiberty University Inc · Lynchburg, VABuilt 2023 · S/N 172S13075 N721AREagle Wings Holdings LLC · Greenwood, INBuilt 2024 · S/N T18209147 N721CTChristiansen Aviation LLC · Wilmington, DEBuilt 2006 · S/N 172S10140 N721EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2023 · S/N 172S13055 N721JJNo More Bites LLC · Alexandria, VAS/N T18209158 N721LULiberty University · Lynchburg, VABuilt 2010 · S/N 172S11056 N721SACommonwealth Of Massachusetts · Bridgewater, MABuilt 1997 · S/N 17280239 N721THAtp Aircraft 7 LLC · Wilmington, DEBuilt 2017 · S/N 172S12011 N721ZASky-Vu Flyers Inc · Fishers, INBuilt 2004 · S/N 18281439 N722EFEpic Aviation Inc · New Smyrna Beach, FLBuilt 2022 · S/N 172S12824 N722HGAmeriflyers Of Florida LLC · Addison, TXBuilt 1998 · S/N 17280402 N722LULiberty University Inc · Lynchburg, VABuilt 2024 · S/N 172S13199 N722MAK2 Aviation LLC · Greenwood Village, COBuilt 2013 · S/N 172S11324 N722PWRamsey Asphalt Construction Corp · Santa Maria, CABuilt 2023 · S/N T18209116 N722SAElmendorf Afb · Elmendorf Afb, AKS/N 17280026 N723CATextron Aviation Inc · Wichita, KSS/N 172S13636 N723DJCesnik John A · Menomonie, WIS/N T18208328 N723HGFlight Operations Aircraft LLC · Wilmington, DEBuilt 1998 · S/N 17280408 N723LULiberty University Inc · Lynchburg, VABuilt 2024 · S/N 172S13202 N723MDTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13487 N723PGPoplar Grove Airmotive Inc · Poplar Grove, ILBuilt 1998 · S/N 17280675 N723SEFrost Cavin Bert · Odessa, TXBuilt 2022 · S/N 18283188 N723SPElite Approach LLC · Chesterfield, MOBuilt 2000 · S/N 172S8657 N723TCWisodak Air LLC · Eau Claire, WIBuilt 2024 · S/N T18209156 N724BF5904 Msl LLC · Tahoe City, CABuilt 2018 · S/N 172S12192 N724EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2023 · S/N 172S13026 N724EWVan Bortel Aircraft Inc · Arlington, TXBuilt 2016 · S/N 18282430 N724LULiberty University Inc · Lynchburg, VABuilt 2024 · S/N 172S13206 N724PGL&W Leasing LLC · Murfreesboro, TNBuilt 1998 · S/N 17280613 N724SPCandace A Larned Enterprises Inc · Long Beach, CABuilt 2000 · S/N 172S8658 N7257EAerospring Leasing LLC · Wasilla, AKBuilt 1999 · S/N 17280760 N7257TJet & Rotor Aviation LLC · Sacramento, CABuilt 1999 · S/N 17280787 N7257ZPrivate Pilot Aircraft Rentals LLC · Sanibel, FLBuilt 1999 · S/N 17280783 N7258RMoynihan Daniel P · Hernando Beach, FLS/N 17280981 N725LULiberty University Inc · Lynchburg, VABuilt 2024 · S/N 172S13209 N725LVAia Echo LLC · Henderson, NVBuilt 2021 · S/N 172S12748 N725PGPoplar Grove Airmotive Inc · Poplar Grove, ILBuilt 1998 · S/N 172S8009 N7260AChristiansen Aviation LLC · Wilmington, DEBuilt 2000 · S/N 17280861 N7260QNaples Flying Club Inc · Naples, FLBuilt 2001 · S/N 18280957 N72612Washington State Dept Of Transp · Tumwater, WAS/N 18280988

Back to AD 2005-05-53 R1