Registered aircraft · 6,034

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.

N1715TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12051 N1717TJaaack Air LLC · Henderson, NVBuilt 2002 · S/N T18208104 N171CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N 172S12332 N171LPFarbish Peter B · Denver, COBuilt 2001 · S/N T18208071 N171MEPatriot Leasing LLC · Franklin, TNBuilt 2000 · S/N 172S8460 N171RACirrus Aviation Inc · Sarasota, FLBuilt 1999 · S/N 172S8237 N171SCAlpha Charlie Aviation LLC · Oregon City, ORS/N 172S12589 N171SPState Of Iowa - Iowa State Patrol · Des Moines, IABuilt 2007 · S/N 18281977 N1720A1720a LLC · Bethany, OKBuilt 2022 · S/N 172S12892 N17223Tao Farm LLC · Ririe, IDBuilt 2007 · S/N 172S10635 N1723ARegistration Pending · Kennesaw, GARegistration pendingBuilt 2026 · S/N 172S13507 N1724LAzul Assets LLC · Santa Fe, NMBuilt 2007 · S/N 18282018 N1724UChristiansen Aviation LLC · Wilmington, DEBuilt 2007 · S/N 172S10443 N1725LMeyer Frank · Williamsburg, VABuilt 2007 · S/N 18282019 N1726TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12052 N17274University Of Alaska Anchorage · Anchorage, AKBuilt 1998 · S/N 17280353 N17297Barrier William · Pensacola, FLBuilt 1997 · S/N 17280140 N172ALRegistered aircraftBuilt 2023 · S/N 172S12931 N172AVFlight Training Aircraft LLC · Wilmington, DEBuilt 2012 · S/N 172S11203 N172BFLewis University · Romeoville, ILBuilt 1997 · S/N 17280175 N172BWThompson Joe Dean · Montgomery, TXBuilt 2005 · S/N 172S9813 N172CNGalvin Flight Services Hawaii LLC · Honolulu, HIBuilt 2020 · S/N 172S12458 N172CYAnson Air LLC · Sugar Land, TXBuilt 2001 · S/N 172S8729 N172DRCunningham Darius L · Sterling, VABuilt 1997 · S/N 17280272 N172EFNorth Shore Aero Club Inc · Beverly, MABuilt 2000 · S/N 17280876 N172ELRegistered aircraftBuilt 2023 · S/N 172S12930 N172FANorthwestern Michigan College · Traverse City, MIBuilt 2012 · S/N 172S11167 N172FKBig Heart Arts LLC · Grass Valley, CABuilt 2013 · S/N 172S11249 N172FNSkyhawk 172 LLC · Eugene, ORS/N 17280004 N172FRHetrick Air Services Inc · Lawrence, KSBuilt 2008 · S/N 172S10728 N172GHNebel & Son Aircraft Leasing Inc · Jacksonville, FLBuilt 1997 · S/N 17280192 N172GWTechau Troy E · Kissimmee, FLBuilt 1999 · S/N 172S8289 N172HGLewis University · Romeoville, ILBuilt 2011 · S/N 172S11139 N172HPSpinnaker Aviation LLC · Conroe, TXBuilt 1997 · S/N 17280274 N172HWLowther Fred · Corvallis, ORBuilt 2000 · S/N 172S8407 N172HXElevation Air Capital LLC · Beloit, WIBuilt 2002 · S/N 172S9263 N172JEBachman Aviation Inc · Winter Haven, FLBuilt 1997 · S/N 17280289 N172JPWnc Aviation LLC · Arden, NCBuilt 1998 · S/N 17280560 N172JVLima-001 LLC · Muscatine, IABuilt 2003 · S/N 172S9420 N172KKIasco Flight Training Inc · Redding, CABuilt 1998 · S/N 17280574 N172KSPlanelogic LLC · St George, UTBuilt 2003 · S/N 172S9481 N172LKPinnacle Aviation Services Inc · Encinitas, CABuilt 1997 · S/N 17280129 N172MTTrede 2020 C172 LLC · Aurora, ORBuilt 2020 · S/N 172S12518 N172RAFjiro Aviation N172ra LLC · Vancouver, WABuilt 2005 · S/N 172S9919 N172RCWings Over Texas Holdings LLC · Denton, TXBuilt 1997 · S/N 17280204 N172RDTop Flight Aviation Inc · Corona, CABuilt 2005 · S/N 172S10045 N172RHMaya Air Services LLC · Lee, NHBuilt 2003 · S/N 172S9432 N172RKEuros Aircraft Leasing LLC · College Station, TXBuilt 1999 · S/N 172S8082 N172RVCsa Aircraft Leasing LLC · Salt Lake City, UTBuilt 2008 · S/N 172S10776 N172SEIcebox Express LLC · Intl Falls, MNBuilt 2021 · S/N 172S12632

Back to AD 2005-05-53 R1