OpenAirDocs.org
AD 80-25-02 R2

Registered aircraft · 6,348

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.

N24477Novotny Randy · New Castle, PABuilt 1979 · S/N 38-79A1125N2447KDamschroder Rex A · Fremont, OHBuilt 1979 · S/N 38-79A0640N24486Wilson Seth · Shafter, CABuilt 1977 · S/N 15280283N2448KCentral Valley Flight School LLC · Hanford, CABuilt 1979 · S/N 38-79A0641N24498Airplanes And Helicopters Of Oregon LLC · Sisters, ORBuilt 1977 · S/N 15280290N24501Dsr Cherokee 180 LLC · Dallas, TXBuilt 1977 · S/N 15280292N2450CCartwright Edward N · Winterville, NCBuilt 1978 · S/N 38-79A0191N2450MProlagayev Sergey · Needville, TXBuilt 1947 · S/N 12-1537N2450NBarton John S III · Gallatin, MOBuilt 1979 · S/N 38-79A0848N24512Moran Erick A · Orange, CABuilt 1977 · S/N 15280300N2451MAccurate Aero LLC · Minden, NVBuilt 1947 · S/N 12-1536N24522Wings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15280309N2452GFlymax Aero LLC Trustee · Dover, DEBuilt 1979 · S/N 38-79A0530N2452TAnywhere Atp LLC · Mt Juliet, TNBuilt 1978 · S/N 38-78A0807N24530Mayfield Jon David · Dublin, TXBuilt 1977 · S/N 15280313N24532Christiansen Aviation LLC · Wilmington, DEBuilt 1977 · S/N 15280315N24540Nelson Scott W · Owasso, OKS/N 38-79A1129N24544Comer Dwayne M · Glendale, AZS/N 15280323N24546Valestin Donald P · Queen Creek, AZBuilt 1977 · S/N 15280325N24553Jensen Aviation LLC · Rancho Cucamonga, CABuilt 1977 · S/N 15280328N24558Pinkerton Tim A · Trotwood, OHS/N 3277N2455MArizona Soaring Inc · Maricopa, AZBuilt 1947 · S/N 12-1674N2456DRegistered aircraftBuilt 1978 · S/N 38-79A0321N2456NCihak Anton W II · Goode, VABuilt 1979 · S/N 38-79A0849N2457APearce Daniel P · New River, AZS/N 38-78A0699N2457GKm Ed LLC · Ocala, FLS/N 38-79A0532N2459AAretz David · Lakeland, FLBuilt 1978 · S/N 38-78A0700N2459GNeely Darin A · Monee, ILBuilt 1979 · S/N 38-79A0534N2459QBerg Gabriel · Port Angeles, WABuilt 1969 · S/N 711N24606Piper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 38-79A1136N2460KL'Hommedieu Susan · Ava, MOBuilt 1979 · S/N 38-79A0643N24611Barrios Sergio · Lusby, MDS/N 38-79A1137N2462CPilots Choice Aviation Equipment Leasing Co · Georgetown, TXBuilt 1978 · S/N 38-79A0197N2462FBlack Coral Holdings LLC · Elm Grove, WIBuilt 1979 · S/N 38-79A0459N2462MPalmenteri Louis J · Rhome, TXBuilt 1947 · S/N 12-1549N2463LBivens Kennett A · Spanaway, WABuilt 1979 · S/N 38-79A0709N2466BFoecking James · Valley City, OHS/N 38-79A0073N2466MDonalds Flying Service Inc · Pantego, NCBuilt 1947 · S/N 12-1687N2467MToelle Neill · Fairbanks, AKBuilt 1947 · S/N 12-1693N2468NSouth Texas Air Force LLC · Mission, TXBuilt 1979 · S/N 38-79A0858N2469KPilot Ready LLC · Lime Springs, IABuilt 1979 · S/N 38-79A0654N246ACMateski James C · Salmon, IDBuilt 1946 · S/N 12-684N246EBeltz Roy C · Leesville, LABuilt 2026 · S/N 8960N24704Blumer Charles · Fullerton, CAS/N 38-78A0785N24708Spartan Education LLC · Tulsa, OKBuilt 1977 · S/N 15280332N24714Bourne Randy D · Orting, WABuilt 1977 · S/N 15280334N24718Piper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 38-80A0002N2471LGuzman Gerald F · Winchester, CABuilt 1979 · S/N 38-79A0712N2471NTwo Dot Aircraft LLC · Kalispell, MTBuilt 1979 · S/N 38-79A0859N24725Technical Education Services Inc · Virginia Beach, VABuilt 1977 · S/N 15280341
Back to AD 80-25-02 R2