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.

N432ERUnicorn Wings LLC · Cary, ILBuilt 1998 · S/N 17280652 N433EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2014 · S/N 172S11455 N433FRKtoa Rentals LLC · Torrance, CABuilt 1997 · S/N 17280292 N433SPAspire Aviation LLC · Farmingdale, NYBuilt 1999 · S/N 172S8301 N434AHSkywest Leasing Inc · St George, UTBuilt 2014 · S/N 172S11456 N434CPCivil Air Patrol · Maxwell Afb, ALBuilt 2009 · S/N 18282192 N434CSBaldwin Scott Ryan · Kamas, UTBuilt 2016 · S/N 18282433 N434EPNashville Flight School LLC · Nashville, TNBuilt 1998 · S/N 17280655 N434SPLlp Leasing Group LLC · Lewes, DEBuilt 1999 · S/N 172S8302 N435CAWingsleasing LLC · Wichita, KSBuilt 2017 · S/N 172S12060 N435SPBoeing Employees Flying Association · Renton, WABuilt 1999 · S/N 172S8304 N435TAPanther Med LLC · Derby, KSBuilt 2001 · S/N 18281035 N436AGSkywest Leasing Inc · St George, UTBuilt 2014 · S/N 172S11457 N436CAWingsleasing LLC · Wichita, KSBuilt 2017 · S/N 172S12061 N436CSBulovic Mark · Savannah, GABuilt 2016 · S/N 18282428 N436PWRegistration Pending · Walnut, CARegistration pendingBuilt 2023 · S/N 172S13044 N436SPHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2001 · S/N 172S8769 N436THSnohomish Flying Service Inc · Snohomish, WABuilt 2020 · S/N 172S12436 N437EPAb Prop Plane II LLC · Metairie, LABuilt 2015 · S/N 172S11605 N437FAWhiskey Charlie Aero LLC · Poway, CABuilt 2003 · S/N 172S9437 N437PSWest Michigan Aviation Academy · Grand Rapids, MIBuilt 2006 · S/N 172S10263 N437SPN437sp LLC · Manassas, VABuilt 1999 · S/N 172S8309 N438CPCivil Air Patrol · Maxwell Afb, ALBuilt 2026 · S/N 18283345 N438ERMorey Airplane Company Inc · Middleton, WIBuilt 2001 · S/N 172S8934 N438SATwopro Energy Services LLC · Odessa, TXBuilt 2016 · S/N 18282421 N438SCAlpha Charlie Aviation LLC · Oregon City, ORBuilt 2018 · S/N 172S12225 N4396DBass Aviation LLC · Lewes, DEBuilt 2023 · S/N T18209122 N439CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282355 N439CSMarionneaux Law Firm LLC · Baton Rouge, LABuilt 2016 · S/N 18282429 N439ERMorey Airplane Co Inc · Middleton, WIBuilt 2001 · S/N 172S8935 N439LPTps Aviation LLC · Los Angeles, CABuilt 2003 · S/N 172S9439 N43TRMeichelle Enterprises Inc · Santa Barbara, CABuilt 2004 · S/N T18208235 N440ERChristiansen Aviation LLC · Wilmington, DEBuilt 2017 · S/N 172S12027 N440FAA-Cent Aviation Inc · Jacksonville, FLBuilt 2003 · S/N 172S9440 N440SPHoletz Consulting Inc · Minneapolis, MNBuilt 2000 · S/N 172S8357 N441CAAtp Aircraft 4 LLC · Wilmington, DEBuilt 1998 · S/N 17280441 N441CPCivil Air Patrol · Maxwell Afb, ALBuilt 2025 · S/N T18209185 N441ERVeve Jesus Vila · Mayaguez, PRBuilt 2005 · S/N 172S10060 N441QFChristiansen Aviation LLC · Wilmington, DEBuilt 1997 · S/N 17280278 N442CROklahoma Aviation LLC · Bethany, OKBuilt 2015 · S/N 172S11519 N442ERChristiansen Aviation LLC · Wilmington, DEBuilt 2017 · S/N 172S12029 N442KSChristiansen Aviation LLC · Wilmington, DEBuilt 2020 · S/N 172S12514 N443EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2021 · S/N 172S12644 N443KSKent State University · Stow, OHBuilt 2020 · S/N 172S12473 N444FRRainier Flight Service LLC · Renton, WABuilt 2015 · S/N 172S11577 N444THAtlas Aviation Tampa Inc · Tampa, FLBuilt 2020 · S/N 172S12440 N444VBYoung Reginald S · Buffalo Junction, VABuilt 2001 · S/N 18281034 N444VWN444vw LLC · Union Gap, WABuilt 2016 · S/N 172S11666 N445AFPlane Nonsense Inc · Middletown, DEBuilt 1998 · S/N 17280445 N445BDornoch Services LLC · Dover, DEBuilt 2005 · S/N 172S9776

Back to AD 2005-05-53 R1