OpenAirDocs.org
AD 80-25-02 R2

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
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.

N90913Prime Travis R · Hammonton, NJS/N 893-73N90915Cnj Flying Inc · Flossmoor, ILS/N 894-73N9091LAmelia Reid Aviation LLC · San Jose, CABuilt 1970 · S/N 784-70N90923Gravesen Mark A · Kenmare, NDS/N 899-73N9092LYoung Vernon P · Metter, GAS/N 785-70N90966Poultry Not Beef LLC · Chancellor, ALBuilt 1972 · S/N 895-73N90968Petrie Robert J · Eagleville, TNBuilt 1972 · S/N 896-73N90969Trinity Aire LLC · Drakesville, IAS/N 897-73N90973Skydive Santa Barbara LLC · Lompoc, CABuilt 1973 · S/N 902-73N9097FFowler David J · Madison, GABuilt 2002 · S/N 01N9097LHoover Mark B · Wasilla, AKBuilt 1970 · S/N 789-71N90987Registration Pending · Turner, MTRegistration pendingBuilt 1973 · S/N 907-73N9098LDavenport Ross K · Raleigh, NCS/N 794-71N90992Fried Bernard S · Spring Branch, TXBuilt 1973 · S/N 908-73N90997Pond Timothy A · Middletown, OHBuilt 1973 · S/N 909-73N90EMMasterson Edward J · Westford, MAS/N 1N9106LShipman Jesse L · Honey Grove, TXBuilt 1970 · S/N 795-71N9107LJ P Aero Holdings Inc · Carson City, NVS/N 796-71N91083Cahill Margaret G · Monroe, WAS/N 12-974N9114LKeller Crop Surveillance LLC · Jonesboro, ARBuilt 1970 · S/N 301-71N9115LSavonen Stephen D · Ukiah, CABuilt 1970 · S/N 797-71N9117Runnels James A · Dublin, TXBuilt 1969 · S/N 2504N911GGGearhart Joe L · Three Rivers, MIBuilt 2001 · S/N 01N91204Registered aircraftBuilt 1995 · S/N AV1059N9120LHarper Kevin J · Valley Center, KSBuilt 1970 · S/N 799-71N9123LAppold Dave J · Bay City, MIBuilt 1970 · S/N 804-71N9130LJohnsen David E · Oklahoma City, OKBuilt 1970 · S/N 805-71N9130RGauger Grant E · Oakland, CAFirst renewal noticeBuilt 1947 · S/N 12-1859N9131Redmon Ronald D · Crestwood, KYBuilt 2011 · S/N B1FBN91315Kearley Greg A · Lafayette, LABuilt 1981 · S/N 38-81A0159N91319Bas Part Sales LLC · Greeley, COS/N 38-81A0147N9131LAeronautical Technical Service Inc · Collierville, TNS/N 806-71N91325Korenko Kirk A · Granite Bay, CABuilt 1981 · S/N 38-81A0163N91332T-32 Associates · Effort, PAS/N 38-81A0168N91341Wheeler Shaun W · Covington, TNBuilt 1982 · S/N 38-82A0007N9136LWelch Thomas R · Rimrock, AZBuilt 1971 · S/N 4-71N91372Higgins Robert S · Granbury, TXBuilt 1981 · S/N 38-81A0169N91383Rieder Josh · Boone, NCBuilt 1981 · S/N 38-82A0021N91386Shred Box LLC · Hayesville, NCBuilt 1981 · S/N 38-82A0022N913JKKing Michelle L · Atlanta, GABuilt 1974 · S/N 1018-74N913TAChristiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 15285317N9140LPretorius Ellen T · Smithville, OHBuilt 1971 · S/N 807-71N91414Richardson James R · Brandon, MSBuilt 1981 · S/N 38-82A0027N9141LAmerican Airpower Heritage Flying Museum · Dallas, TXS/N 808-71N9152LBaker Glen M · El Reno, OKBuilt 1971 · S/N 810-71N91544Piper Aircraft Inc · Vero Beach, FLBuilt 1981 · S/N 38-82A0050N915AAHoecher Robert T · Anchorage, AKFirst renewal noticeBuilt 1977 · S/N 15280359N9169NWestern Sky Aviation Warbird Museum Inc · St George, UTBuilt 2002 · S/N 3004N916TBShearer Gregory L · Avon, INBuilt 1987 · S/N 1690N9174HBarf Aviation LLC · Huntsville, ALBuilt 1946 · S/N 12-288
Back to AD 80-25-02 R2