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.

N2507DMurphy Robert Joseph · Galveston, TXS/N 38-79A0344N2507MEller Ralph E · Wasilla, AKBuilt 1946 · S/N 12-1005N2508ZAmelia Reid Aviation LLC · San Jose, CABuilt 1978 · S/N 1249-78N25091Piper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 38-80A0029N2509AEagle Aviation LLC · Benton, KYBuilt 1978 · S/N 38-78A0724N250TWhite William Brian · Apex, NCBuilt 1953 · S/N 18-2364N2510GCollum Aviation LLC · Milton, FLBuilt 1967 · S/N 403N2511MAustin Air Cruisers LLC · Dripping Springs, TXS/N 12-1009N2512LHartsock Jane R · Laurens, IABuilt 1979 · S/N 38-79A0741N2512NArias Kevin · Cheverly, MDBuilt 1979 · S/N 38-79A0856N2513Carlson Elmer A · Enumclaw, WARegistration revokedBuilt 1967 · S/N 1513N25137Piper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 38-80A0034N2513AHarris Alden F · Shrewsbury, MABuilt 1978 · S/N 38-78A0727N25140Piper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 38-80A0036N2516BPearlsnap Solutions LLC · Georgetown, TXBuilt 1978 · S/N 38-79A0101N2516CStrong Don E Jr · Mountain Home, ARBuilt 1978 · S/N 38-79A0211N2517BJobe Dwaine B · Chilhowee, MOBuilt 1978 · S/N 38-79A0102N2517CGrimes John M · Santa Maria, CABuilt 1987 · S/N 1474N2518FWill Larry P · Fort Collins, COBuilt 1966 · S/N 136N2518LKerber John · Decorah, IABuilt 1979 · S/N 38-79A0749N2519BWagner Douglas L · Newbury Park, CABuilt 1984 · S/N 830N251TGelvin Stanley M · Central, AKBuilt 1946 · S/N 12-254N2520ARaptor Flight LLC · Fort Worth, TXS/N 38-78A0730N2520BRegistration Pending · Cheshire, CTRegistration pendingBuilt 1978 · S/N 38-79A0105N25216Mcfarlane Claude L III · Fitchburg, WIBuilt 1977 · S/N 15280534N25221Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15280538N25225Howard Jeff S · Anderson, SCBuilt 1977 · S/N 15280541N25228Laguna Verde Leasing Inc · Wilmington, DES/N 15280543N2522CKlamecki Alan P · Phoenix, AZBuilt 1978 · S/N 38-79A0216N25233Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15280545N2523BJenny Joe S · Fresno, CABuilt 1978 · S/N 38-79A0107N2524FWilkins Shelley A · Claremore, OKBuilt 1966 · S/N 72N25252Scott Wilson A · Norman, OKBuilt 1980 · S/N 38-80A0005N25255Flm Aviation LLC · Vernal, UTBuilt 1977 · S/N 15280556N2525BOn Course LLC · Saint Charles, MOBuilt 1978 · S/N 38-79A0108N2525FGarbani Jacob R · Caldwell, IDBuilt 1966 · S/N 419N25269Yankaskas Kurt D · Ijamsville, MDBuilt 1977 · S/N 15280563N25271Byrnes Daniel P · Anchorage, AKS/N 15280564N25284Riverside Flight Center Inc · Tulsa, OKBuilt 1977 · S/N 15280572N25286Recreational Enterprises LLC · Sanford, FLS/N 15280573N25287Greenwood John R · Bellevue, NEBuilt 1980 · S/N 38-80A0107N2528BMankowski Luke Ray · Granbury, TXBuilt 1978 · S/N 38-79A0110N252MTAero Quest LLC · Olive Branch, MSBuilt 1977 · S/N 15280407N252SFConlisk Christopher M · Hephzibah, GABuilt 2007 · S/N 66285N252TJanssen Jerry D · Barnesville, MNBuilt 1953 · S/N 18-2366N252WCMosier Paul L · Ventura, CABuilt 1979 · S/N 15284145N252ZMason Jerry J · Lebanon, ORBuilt 1965 · S/N JM-1N25301Southern Arkansas University Technical Branch · Camden, ARBuilt 1977 · S/N 15280581N25302Steiner Jason A · Sabetha, KSBuilt 1977 · S/N 15280582N2530NGibbs Robert I · Ravenswood, WVBuilt 1979 · S/N 38-79A0899
Back to AD 80-25-02 R2