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.

N331JKKenzy 2020 LLC · Aurora, ORBuilt 2021 · S/N 172S12751 N331MEHarrison Matthew T · Naponee, NEBuilt 2000 · S/N 172S8464 N331MSAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2007 · S/N 18282021 N331RPRaritan Valley Flying School · Princeton, NJS/N 172S9863 N332CPCivil Air Patrol · Maxwell Afb, ALBuilt 2018 · S/N 172S12137 N332MCClover Park Technical College · Lakewood, WABuilt 2026 · S/N 172S13551 N332SPMh Aviation LLC · Foster City, CABuilt 2020 · S/N 17281118 N3338VAero-Tech Services Inc · Lititz, PABuilt 2025 · S/N 172S13307 N333FRHofstetter Seth · Jacksonville, ORBuilt 2024 · S/N T18209131 N333JEJs Aviation Inc · Valparaiso, INBuilt 2026 · S/N 172S13562 N333PFDennis Bruce · Hesperus, COBuilt 2011 · S/N T18209027 N333TCKaty Partnership Leasing LLC · Watertown, SDBuilt 2025 · S/N T18209166 N333TSAerostar Management Services LLC · Kissimmee, FLBuilt 1999 · S/N 172S8240 N334SPSierra Pop Air LLC · Wilmington, DEBuilt 2003 · S/N 172S9494 N335MCLewis University · Romeoville, ILBuilt 2022 · S/N 172S12879 N335MECentral Iowa Aviation LLC · Ankeny, IABuilt 2000 · S/N 172S8466 N335SPMaui Aviators LLC · Pukalani, HIBuilt 2003 · S/N 172S9495 N336CPCivil Air Patrol · Montgomery, ALBuilt 2010 · S/N T18209012 N336MCLewis University · Romeoville, ILBuilt 2022 · S/N 172S12880 N337CPCivil Air Patrol · Maxwell Afb, ALBuilt 2020 · S/N 18283116 N337CRElder Bruce W · Farmington, NMBuilt 2004 · S/N T18208259 N337DBOlson Vienette · White Bear Lake, MNBuilt 2001 · S/N 18281027 N337MEFlytcentrix LLC · Lewes, DES/N 172S8468 N338GSSanders Flight Training Center Inc · Jasper, ALBuilt 2025 · S/N 172S13326 N339SPCahill Michael · Moon Township, PABuilt 2003 · S/N 172S9496 N33FMAtp Aircraft 7 LLC · Wilmington, DEBuilt 2012 · S/N 172S11196 N33HARykris Investments LLC · Bowling Green, KYBuilt 2011 · S/N 18282279 N33LAOscar Tango LLC · Mesa, AZBuilt 2020 · S/N 172S12446 N340MTAcron Aviation Academy Inc · Sanford, FLBuilt 2006 · S/N 172S10374 N341CPCivil Air Patrol · Maxwell Afb, ALBuilt 2026 · S/N 172S13499 N341SPSo Cal Leasing LLC · El Cajon, CABuilt 2003 · S/N 172S9497 N342SASunrise Aviation Inc · Ormond Beach, FLS/N 172S10475 N342TSDaniels Law · Sherman Oaks, CABuilt 2001 · S/N T18208040 N343CACivil Air Patrol · Maxwell Afb, ALBuilt 2025 · S/N 18283310 N343CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N 172S12344 N343PTDiamond Head Aviation LLC · Kunia, HIBuilt 2005 · S/N 172S9831 N343SASunrise Aviation Inc · Ormond Beach, FLBuilt 2007 · S/N 172S10477 N343SPEight16 LLC · Lewes, DEBuilt 2003 · S/N 172S9498 N343TCTwo Rivers Aircraft Managmenet LLC · Williamsburg, VABuilt 2004 · S/N T18208344 N344CACivil Air Patrol · Maxwell Afb, ALBuilt 2008 · S/N 18282137 N344JEAlf Ix LLC · Chicago, ILBuilt 2026 · S/N 172S13472 N344RBContinental Aerospace Technologies Inc · Mobile, ALBuilt 2011 · S/N 172S11133 N344SPSun City Aviation LLC · Davie, FLBuilt 1999 · S/N 172S8267 N345BPeraton Services LLC · Venice, CABuilt 1999 · S/N 172S8177 N345CMScherson David Alejandro · Folsom, CABuilt 2010 · S/N T18209016 N345CSFlight Training Aircraft LLC · Wilmington, DEBuilt 2015 · S/N 172S11527 N345FHHeavy Metal Air LLC · Farmingdale, NYBuilt 2012 · S/N 172S11160 N345MEOtt James E · Redlands, CABuilt 2000 · S/N 172S8577 N345RKButler Management LLC · Sherman Oaks, CABuilt 2007 · S/N T18208790 N345TJOpa Flys LLC · Magnolia, TXBuilt 2004 · S/N 18281469

Back to AD 2005-05-53 R1