Skip to content

Registered aircraft · 6,349

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:80-25-02-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-02-R2') 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:80-25-02-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-02-R2')
  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:80-25-02-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-02-R2')
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.

N5093QRiya Aviation LLC · Tracy, CABuilt 1981 · S/N 15285073 N5093ZSelby Gerald A · Sand Springs, OKBuilt 1961 · S/N 22-8727 N5094LGorge Winds Aviation Inc · Fairview, ORBuilt 1980 · S/N 15284260 N5095PGyrfalcon Air Holdings LLC · Boise, IDS/N 15284875 N5096DSchrader Thomas R · Anchorage, AKBuilt 2008 · S/N 01 N5096LPea-Wayman Flight LLC · Daytona Beach, FLBuilt 1980 · S/N 15284262 N5097ZMoore Jay G · Billings, MTS/N 2 N5098ZHanlon Ronald J · Seattle, WABuilt 1961 · S/N 22-8734 N5099ZKaufold E Richard · Ridge, NYBuilt 1961 · S/N 22-8735 N50RBBenson Ross A · Granbury, TXBuilt 1987 · S/N 757 N5100QTulsa Technology Center School District 18 · Tulsa, OKBuilt 1981 · S/N 15285075 N5100ZLawrence Richard J · Wooster, OHBuilt 1961 · S/N 22-8736 N5101HAberdeen Flying Service · Aberkeen, SDBuilt 1979 · S/N 15284061 N5103TReace Enterprises LLC · Woodbury, MNBuilt 1966 · S/N 441 N5103Z92nd West Aviation Inc · Lonoke, ARS/N 22-8739 N5104TConsolidated Aviation Services LLC · Seymour, TNBuilt 1966 · S/N 496 N5104ZGary L Morton · Palmer, AKBuilt 1961 · S/N 22-8740 N5105MAscend Aviation LLC · Bountiful, UTBuilt 1980 · S/N 15284499 N5105TRider Charles A · Kokomo, INBuilt 1966 · S/N 502 N5105ZKrumm Melvin L · Allegan, MIBuilt 1961 · S/N 22-8741 N5106BBabcock Lori A · Salina, KSBuilt 1979 · S/N 15283747 N5106ZDorsey James P · Bainbridge Island, WABuilt 1961 · S/N 22-8746 N5107BWest Valley Flying Club · Palo Alto, CABuilt 1979 · S/N 15283748 N5108LHellix LLC · Charlotte, NCS/N 15284266 N5109BOverlander Aviation LLC · Palo Alto, CABuilt 1979 · S/N 15283750 N5109XHarkema James P · Troy, OHBuilt 1969 · S/N 663 N510MEdwards Christopher A · Warrenton, VABuilt 1971 · S/N 1171 N5111XJeter Michael C · Jacksboro, TXBuilt 1969 · S/N 664 N5111ZSlaughter Don Wayne · Farmville, NCBuilt 1961 · S/N 22-8751 N5112TStevens Richard N · Venice Center, NYBuilt 1966 · S/N 534 N5113TSchaffner David A · Wray, COBuilt 1966 · S/N 516 N5113XHemstock Ronn · Seward, AKBuilt 1969 · S/N 666 N5113ZNielsen Jeffrey L · Harlan, IAS/N 22-8754 N5115ZSager Charles J Jr · Wofford Heights, CABuilt 1961 · S/N 22-8756 N5116QAvolant Aviation LLC · Mooresville, NCBuilt 1981 · S/N 15285078 N5117ZWroe Daniel · Denton, MDBuilt 1961 · S/N 22-8758 N5118ZToner Phillip A · Devine, TXS/N 22-8759 N5119TAmelia Reid Aviation LLC · San Jose, CABuilt 1966 · S/N 200 N511CEWesolowski Chris E · Anchorage, AKBuilt 2019 · S/N 2004 N5120HTraining Planes LLC · Tampa, FLBuilt 1979 · S/N 15284063 N5120TPrince Ronald D · Beach City, OHBuilt 1966 · S/N 479 N5121TBourn Rachael · Magee, MSBuilt 1966 · S/N 307 N5121ZDahlberg Thomas K · Belvidere, ILBuilt 1961 · S/N 22-8762 N5122BTutt Bryan D · Louisville, KYBuilt 1979 · S/N 15283759 N5122PBluesky Equipment LLC · Panama City, FLBuilt 1981 · S/N 15284882 N5122ZDunn Kohlten Davis · Rexburg, IDBuilt 1961 · S/N 22-8763 N5124BHillsboro Aero Academy Llcc · Hillsboro, ORBuilt 1979 · S/N 15283761 N5124HFowler Thomas J · Keller, TXBuilt 1948 · S/N 14-130 N5124ZCummings Christopher K · Chalfont, PABuilt 1961 · S/N 22-8765 N5125BSnohomish Flying Service Inc · Snohomish, WABuilt 1979 · S/N 15283762

Back to AD 80-25-02 R2