OpenAirDocs.org
AD 80-25-07 R1

Registered aircraft · 25,369

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-07-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:80-25-07-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.

N88437Vst Aviation LLC · Ball Ground, GABuilt 1974 · S/N 490-75N88443Jkt LLC · Douglas, WYBuilt 1974 · S/N 130-75N88446Gall Peter D · Morgantown, WVS/N 1064-75N8845Rudloff Uwe K · Lake Village, INBuilt 1973 · S/N 365-73N88451Williams Charles S · Pearland, TXS/N 131-75N88453Tribfelner Lance J · St Charles, MIBuilt 1974 · S/N 1065-75N88458Cole John R · Greenfield, INBuilt 1975 · S/N 790-75N88459Carnevale Victor N · Fayetteville, NCBuilt 1974 · S/N 1067-75N88465Castleberry Inc · Ekalaka, MTBuilt 1974 · S/N 791-75N88467Atwood Christopher M · Brownsburg, INBuilt 1974 · S/N 163-75N88473A C E Aviation Inc · Ashton, IDBuilt 1974 · S/N 306-75N88476Bmg Aviation Inc · Bloomington, INBuilt 1974 · S/N 495-75N88477Holland William T III · Midway, ARBuilt 1974 · S/N 136-75N884CAColeman Aero Club · Apo AeBuilt 1978 · S/N 17271876N884JSCrane John R · Niceville, FLBuilt 1977 · S/N 340-77N8857Aviation Management Systems LLC · Fallbrook, CABuilt 1973 · S/N 254-73N885JBrandaleone Nicholas · Somerville, MABuilt 1990 · S/N 24-3192N885WAMorcom Aviation Services Inc DBA · Everett, WAS/N 15280190N8868Hodges Jay W · Graham, TXBuilt 1973 · S/N 931-73N886PBarrons Aviation Services LLC · Henderson, NVBuilt 1962 · S/N 2328N886THMock Joseph R · Huntsville, TXBuilt 1974 · S/N 142-74N887BCAustin Aviation LLC · Boise, IDBuilt 2023 · S/N 627-2023N887PAReall George Dan · Castle Rock, COBuilt 2016 · S/N 1162-2016N8881VLien Ronald N · Gilford, NHS/N 17264240N8882VTop Aircraft Leasing LLC · Wilmington, DEBuilt 1974 · S/N 17264241N8883Harris James H · Gardner, KSBuilt 1973 · S/N 932-73N8888NGibson Edward J · Marmora, NJBuilt 1967 · S/N 7KCAB-58N8889VGarcia Hector A · Caguas, PRBuilt 1974 · S/N 17264247N888BTSpraymax Corp · Miami, FLBuilt 1974 · S/N 18801782TN888CBBenz James E · Pittsford, NYBuilt 1974 · S/N 17264417N888CMKelley Aircraft LLC · Weyers Cave, VABuilt 1976 · S/N 17267424N888DFAslin Wesley Keith · Auburn, CABuilt 1992 · S/N 24-3254N888ECArrow Aviation LLC · Noblesville, INS/N P21000076N888GACain Philip K · Escondido, CAS/N 17268107N888HFFlight1 Hsw LLC · Norwood, COBuilt 1981 · S/N P21000658N888KCGrimes Joshua R · Lock Haven, PABuilt 1978 · S/N 38-78A0115N888LEStockton Raymond L · Pearl City, HIS/N 15279620N888PJPatterson Edward · Midland, TXBuilt 1981 · S/N 21064244N888TACurrier Winston F · Monroe, NHBuilt 1975 · S/N 17266196N888TBBlock Scott · Chandler, AZFirst renewal noticeBuilt 1969 · S/N 17257895N888VMDaniels Michael R · Mc Donald, PABuilt 1973 · S/N 17702021N8890VBig Q Aviation · Helena, MTBuilt 1974 · S/N 17264248N8891VPropel Air LLC · Pottstown, PABuilt 1974 · S/N 17264249N8892VBillingsley Carl R · Henderson, TXBuilt 1974 · S/N 17264250N8893VEast Tennessee Pilots Club · Knoxville, TNBuilt 1974 · S/N 17264251N8894Buth Elizabeth · Wasilla, AKBuilt 1973 · S/N 478-73N8894VBeckworth Brad T · Jacksonville, FLBuilt 1974 · S/N 17264252N8896Ausbun Taylor J · North Pole, AKBuilt 1973 · S/N 480-73N8897Cavett Wanda A · Enderlin, NDS/N 934-73N889GSKlock Dexter F · Driggs, IDBuilt 2000 · S/N 853-99
Back to AD 80-25-07 R1