OpenAirDocs.org
AD 80-25-02 R2

Registered aircraft · 6,349

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.

N68418Moore Michael P · Houston, TXBuilt 1978 · S/N 15282289N6844KNoguess Levi B · Belton, TXBuilt 1949 · S/N 16-678N68459Airplanes And Helicopters Of Oregon LLC · Sisters, ORBuilt 1978 · S/N 15282303N6845KGottfried Virgil P · Wilkesboro, NCBuilt 1949 · S/N 16-679N68475California In Nice Inc · San Jose, CABuilt 1978 · S/N 15282311N68477Freiburger Thomas M · Belvedere, CABuilt 1978 · S/N 15282312N6847KWilson Galen B · Belchertown, MAS/N 16-681N68485Dkg Cessna LLC · Flagler Beach, FLS/N 15282313N68509Luvsflying Flight Training LLC · Staten Island, NYS/N 866-72N68515Gator Flight LLC · Saint Cloud, FLBuilt 1972 · S/N 867-72N68522Registration Pending · Anchorage, AKRegistration pendingBuilt 1972 · S/N 864-72N68525N917az LLC · Miami, FLBuilt 1972 · S/N 871-72N68526Vapor Global Aviation LLC · Munford, TNBuilt 1972 · S/N 869-72N68527Morton Jerry D Jr · Dade City, FLBuilt 1972 · S/N 870-72N68533Sunrise Aviation Company · Santa Ana, CABuilt 1972 · S/N 873-72N6854KMountain Air · Cody, WYBuilt 1949 · S/N 16-689N6856KWyborny Elton D · Scotland, ARBuilt 1949 · S/N 16-692N68570Chmiel John P · Wausau, WIBuilt 1972 · S/N 878-72N68575Kushner Herbert A · Bridgewater, NJBuilt 1972 · S/N 879-72N68579Schaefer Gerard P · Olive Branch, MSBuilt 1972 · S/N 880-72N6858KPreston Benjamin J · Sonoma, CABuilt 1949 · S/N 16-694N6859KShelton Gregory S · Midlothian, VABuilt 1949 · S/N 16-695N685JWGiurtino Joel F · Spring Hill, FLS/N 868-72N68608Oxford Aircraft Leasing LLC · Oxford, NCBuilt 1978 · S/N 15282317N6865KSvendsen Jon · Wasilla, AKBuilt 1949 · S/N 16-701N6867KFloyd Roger L · Sedan, KSS/N 16-703N68688Registered aircraftS/N 15282322N6869KFelix Leonard D Jr · Salome, AZBuilt 1949 · S/N 16-704N6870KYruegas Luis Jr · San Antonio, TXBuilt 1949 · S/N 16-705N68714Registration Pending · Iuka, ILRegistration pendingBuilt 1981 · S/N 15285332N68735Pittsburgh Institute Of Aeronautics · West Mifflin, PABuilt 1978 · S/N 15282345N68736Lake Elmo Aero LLC · Lake Elmo, MNS/N 15282346N68742Byars Cecil E · Tupelo, MSBuilt 1978 · S/N 15282351N68750Poplar Grove Airmotive Inc · Poplar Grove, ILBuilt 1978 · S/N 15282356N68754Ace Aircraft Leasing Inc · Nazareth, PABuilt 1978 · S/N 15282358N68767Snohomish Flying Service Inc · Snohomish, WABuilt 1978 · S/N 15282367N68768Harris Thomas W · Roseville, MNBuilt 1978 · S/N 15282368N6876KAndrews Thomas J · Lakeview, ORS/N 16-717N68775Gruca Paul G · Riverdale, MIBuilt 1981 · S/N 15285337N6877KLaurienzo Andrew A · Clarence, NYBuilt 1949 · S/N 16-720N68789Sinden Donald L · Puyallup, WABuilt 1978 · S/N 15282374N6878KMitchell David R · Conover, NCBuilt 1949 · S/N 16-721N68799Smtm Holdings Inc · Wilmington, DEBuilt 1978 · S/N 15282382N68806G&M Aircraft Inc · Wheat Ridge, COS/N 15282383N68808Mrb Aviation Inc · Lexington, SCBuilt 1978 · S/N 15282384N68810Air-Planes LLC · Soddy Daisy, TNBuilt 1978 · S/N 15282385N68812Avcorp Holdings Inc · Jackson, MIBuilt 1981 · S/N 15285339N68813Vogt Jeffrey D · Pleasant Grove, CAS/N 15282388N68814Spooner Wade G · Donalsonville, GABuilt 1978 · S/N 15282389N68815Skippy Aviation LLC · Bridgeport, PAS/N 15282390
Back to AD 80-25-02 R2