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.

N66VSEurovation Inc Trustee · KematenBuilt 1979 · S/N P21000421N66WSDighans Murray · Peerless, MTBuilt 1979 · S/N P210-00363N6700HNashua Flyers Inc · Nashua, NHBuilt 1975 · S/N 17265543N6700PAbraham Curtis · Byron, WYBuilt 1978 · S/N P21000200N6701NFreeman Alan M · San Antonio, TXS/N 680040N67022Mccormack James · Mount Jewett, PABuilt 1970 · S/N 17259032N6702HGoetz Terry L · Defiance, IABuilt 1975 · S/N 17265545N6702NRoman Jose Ernesto · Guaynabo, PRBuilt 1968 · S/N 680080N6702UKruse Benjamin · Phoenix, AZS/N 2434N6704EWings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 17272052N6704NBethel William C · Murray, KYBuilt 1968 · S/N 680081N6705NGerback Andrew · East Canton, OHBuilt 1968 · S/N 680042N6706HDairy Air Inc · Wyoming, PABuilt 1975 · S/N 17265547N6706NKorn Richard Mark · Lexington Park, MDBuilt 1968 · S/N 680082N6707HWjt Investments LLC · Gurley, ALBuilt 1975 · S/N 17265548N6707NRegistered aircraftBuilt 1968 · S/N 680043N6708UBlaedow Kyle R · Leesville, LAS/N 2440N6710NJohnson Kenneth W · Pine Bluff, ARBuilt 1968 · S/N 680084N6710UMonroe Flying Club Inc · Glen Carbon, ILBuilt 1963 · S/N 2442N6711NHanna William R · Castle Rock, COBuilt 1968 · S/N 680045N6711UUlassin Kyle B · Corvallis, ORBuilt 1963 · S/N 2443N6712USchell Kerry A · Arvada, COBuilt 1963 · S/N 2444N6713UHinds Casey L · Seattle, WABuilt 1963 · S/N 2445N6714NLawler Thomas W Jr · French Lick, INBuilt 1968 · S/N 680086N6715NWomble Phillip A · Enid, MSBuilt 1968 · S/N 680047N6716NAmyett Stanley B · Brady, TXBuilt 1968 · S/N 680087N6716UPickworth Jonathan · Philadelphia, PABuilt 1963 · S/N 2448N6717EDenrow Limited Lc · Shawnee, OKBuilt 1978 · S/N 17272055N6717NGaskill David E · Toledo, WABuilt 1968 · S/N 680048N6718NHoefly Christopher S · Belleview, FLBuilt 1968 · S/N 680175N6718UBerra Robert J · Burtonsville, MDBuilt 1963 · S/N 2450N6719URegistered aircraftBuilt 1963 · S/N 2451N671DBThomas Andreas P · Bend, ORBuilt 1967 · S/N 670030N671RMKapp Florian C · Lagrange, KYBuilt 2002 · S/N 463-2002N671SAKuhn Ent Inc · Manilla, INBuilt 2002 · S/N 460-2002N6720NWatson Andrew J · Chelmsford, MABuilt 1968 · S/N 680176N6720UGilt Michael F · Raleigh, NCBuilt 1963 · S/N 2452N6722NShipman Jesse L · Honey Grove, TXBuilt 1968 · S/N 680177N6723UHohn Jeffrey A · Townville, SCBuilt 1963 · S/N 2455N6725NB Ryan Enterprises Inc · Lynnfield, MABuilt 1968 · S/N 680052N6726NBritsch Uwe K DBA · Klamath Falls, ORBuilt 1967 · S/N 167N6727HAldora Enterprise LLC · League City, TXBuilt 1975 · S/N 17265558N6727NCroney Mark J · Lawrenceville, GABuilt 1968 · S/N 680053N67282Grandy Boyd · Arcadia, CABuilt 1978 · S/N 15281722N67286Mars Aerospace Inc · Bay Shore, NYBuilt 1978 · S/N 15281725N67289Cosklo Ronald J · Fell Township, PABuilt 1981 · S/N 15285291N6728UReed Walter D · Lahoma, OKBuilt 1963 · S/N 2460N67292Mock Joseph R · Huntsville, TXBuilt 1978 · S/N 15281728N6729NAnderson Douglas E · Winchester, ORFirst renewal noticeBuilt 1968 · S/N 680054N672FCBlackhawk Holding Corp · Wilmington, DEBuilt 1980 · S/N 17273897
Back to AD 80-25-07 R1