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.

N2794Autry Timothy R · Stedman, NCBuilt 1971 · S/N 80AN2794MRifenburg Brian K · Ward Cove, AKS/N 12-1252N279TAspenglow LLC · Talkeetna, AKS/N 18-2393N27CWRebr Holdings LLC · Hernando, FLS/N 711N27HSSchooler Harold L · Chico, CABuilt 1980 · S/N HS-1N27KDArnold Lon B · Huntington, UTBuilt 1984 · S/N 667N27RBBassett Ronald E · Monticello, INBuilt 1984 · S/N 1097N27RDWengerd Lavern W · Heron, MTBuilt 1946 · S/N 3969N27ZARegistered aircraftS/N 200027N28Registration Pending · Palos Park, ILRegistration pendingBuilt 1962 · S/N 1N2800DHamann Russell M · Clear Lake, SDBuilt 1947 · S/N 12-1637N2802MSkyone Aero Services LLC · Castro Valley, CABuilt 1977 · S/N 28-7816312N2806WOllmann Paul W · Poplar Grove, ILBuilt 1995 · S/N 1N2809MCarlos Sean N · Togiak, AKBuilt 1946 · S/N 12-1265N280AMSabol John · Smithville, TXBuilt 2004 · S/N 20-1041N2810MDavis Ronald L Jr · Soldotna, AKBuilt 1946 · S/N 12-1263N2811GNablo Dustin · Haddam Neck, CTBuilt 1967 · S/N 170N28143Powell Kenneth W · Ann Arbor, MIBuilt 1940 · S/N 5-116N28144Maloy Toby · Albuquerque, NMS/N 5-117N28151Stewart Thomas · Churchville, NYBuilt 1940 · S/N 5-119N2815TNorwest Ventures LLC · Sagle, IDBuilt 1978 · S/N 15282250N2818GRenda Joseph · Dunnellon, FLBuilt 1967 · S/N 515N2819MDzr Enterprises LLC · Missoula, MTBuilt 1946 · S/N 12-1174N2820MFlynt Gary J · Baytown, TXBuilt 1946 · S/N 12-1172N2821MPacker Louis M · Wasilla, AKBuilt 1946 · S/N 12-1171N2823MFedorka Paul R Trustee · Soldotna, AKBuilt 1946 · S/N 12-1409N2827MAdams James M · Pontiac, ILBuilt 1946 · S/N 12-1306N2828GSparrow Hawk Aviation LLC · Moraine, OHS/N 84N282CGCampbell Tanner · Augusta, KSS/N 1N2830GSandoval Jennifer · Tucson, AZBuilt 1967 · S/N 351N2832GFields Michael L · Rockwood, TNBuilt 1967 · S/N 475N2836MSwihart Matthew S · Hood River, ORBuilt 1946 · S/N 12-1273N2837Helgeson Echeverri Mary Ann B · Surprise, AZBuilt 1969 · S/N 3N283AMRegistration Pending · Gulfport, MSRegistration pendingBuilt 2004 · S/N 20-1048N283THall Terry A · Pennsboro, WVBuilt 1953 · S/N 18-2397N2845MBrasher Kerry W · Scotts Hill, TNBuilt 1946 · S/N 12-1191N2850GSlip And Skid LLC · Sanger, TXS/N 510N2850MHarvey Timothy A · Colusa, CABuilt 1946 · S/N 12-1190N2853MH&M Aviation · Hazelton, NDBuilt 1946 · S/N 12-1187N285TCooper John H III · Wasilla, AKBuilt 1953 · S/N 18-2399N2862MFrederick David · Juneau, AKBuilt 1946 · S/N 12-1285N2868ZWanda Collins Professional Pilot Services LLC · Madisonville, TXBuilt 1978 · S/N 1237-78N2869GRay Richard A · Morristown, NJBuilt 1967 · S/N 533N286THenry James G · Bonita, CABuilt 1953 · S/N 18-2400N2870MJohnson James F · Florence, MTBuilt 1946 · S/N 12-1199N2875MSzumal Brent · Wasilla, AKBuilt 1946 · S/N 12-1404N2876MJohnson William A · Dillingham, AKS/N 12-1304N2877HHeusdens Mark A · Kansasville, WIBuilt 1946 · S/N 3502N287EBBoorom Mikel E · Jackson, MIBuilt 1978 · S/N 1265-78N287TMiller Timothy P · Anchorage, AKBuilt 1953 · S/N 18-2401
Back to AD 80-25-02 R2