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.

N6252UBrown Joshua W · Pomona, ILBuilt 1995 · S/N 20-0006N6256LGuy Jon C · Margate, FLS/N AA1-0456N6257LBearden Robert · Chatsworth, GABuilt 1971 · S/N AA1-0457N6258LGreene Carl E · Hayden, IDBuilt 1971 · S/N AA1-0458N625KBDoran Jeffrey T · Westerville, OHBuilt 1974 · S/N 1057-74N6260LHaas Douglas W · Lodi, CABuilt 1972 · S/N AA1B-0060N6262QNess David R · Ocklawaha, FLBuilt 1981 · S/N 15285213N6263LHarvatine Samuel J · Queen Creek, AZS/N AA1B-0063N6264LLunnie Leisha N · Thompson, NDBuilt 1972 · S/N AA1B-0064N6265ALewis Albert D · Newark, OHBuilt 1978 · S/N 38-78A0356N62669Eckelman Keith R · Culver, ORBuilt 1946 · S/N 7AC-1078N6266AGhaemi Mike · West Hills, CABuilt 1978 · S/N 38-78A0359N6268LMcmillin James · Charlotte, NCS/N AA1B-0068N6269LScotty Express LLC · Gilbert, AZS/N AA1B-0069N626KPSchultz Kenneth L · Mohave Valley, AZBuilt 2018 · S/N 65-10646N626MDaigle Christopher C · Crowley, LAS/N 960N626PABird Acquisition LLC · Phoenix, AZBuilt 1977 · S/N 15281199N6272LAerospace Trust Managment LLC Trustee · Wilmington, DES/N AA1B-0072N6274LTitterton Edward G III · Philadelphia, PABuilt 1980 · S/N 15284383N6275LGeorge Joshua · Chandler, AZBuilt 1972 · S/N AA1B-0075N6276LGroeber Michael D · Ardmore, OKBuilt 1972 · S/N AA1B-0076N6276PHoecher Robert T · Anchorage, AKS/N 15284993N6279MBlanchard Michael J · Cleveland, ARBuilt 1980 · S/N 15284650N6279PIndiana State University · Terre Haute, INBuilt 1981 · S/N 15284994N627FFisher Steven C · Chuckey, TNBuilt 2005 · S/N 001N627JSJds-3 LLC · Wesley Chapel, FLBuilt 1971 · S/N AA1A-0142N627YGlaser Donald E DBA · Willow, AKBuilt 1946 · S/N 12-47N6281LFridley R Mark · Owasso, OKBuilt 1972 · S/N AA1B-0081N6282MBruce Robert W · Frontenac, MNBuilt 1980 · S/N 15284651N6283HMiddleton David E Trustee · Salina, KSFirst renewal noticeBuilt 1946 · S/N 19467N6284LStrusa Steven J · Portsmouth, VABuilt 1972 · S/N AA1B-0084N6286MHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1980 · S/N 15284654N6289ABright James D · Clyde, NCS/N 38-78A0365N6289LSnyder Gary M · Chino, CABuilt 1972 · S/N AA1B-0089N6290APfeifer Carol A · Victoria, KSS/N 38-78A0366N6290LMooney Chance · Collins, MSBuilt 1972 · S/N AA1B-0090N6291LDancy Isaiah A · Richwood, WVBuilt 1972 · S/N AA1B-0091N6293HSpace Coast Aircraft Co · Merritt Island, FLBuilt 1979 · S/N 15284150N6294LSmith Samantha K · Middleburg, FLBuilt 1972 · S/N AA1B-0094N6294MN6294m LLC · Boynton Beach, FLBuilt 1980 · S/N 15284657N6295LGordon Fredrick · Brooksville, MSBuilt 1972 · S/N AA1B-0095N62975Quintessence World LLC · League City, TXBuilt 1972 · S/N 861-72N62977Borgerding Richard · Piqua, OHBuilt 1972 · S/N 855-72N6298MLapham John R · Palm Beach Gardens, FLBuilt 1980 · S/N 15284660N62TFelix Leonard D Jr · Salome, AZS/N 623N6300LHanson Kirk R · Asheboro, NCBuilt 1971 · S/N AA1A-0300N6300QPea-Wayman Flight LLC · Daytona Beach, FLBuilt 1981 · S/N 15285225N6301LHarding Benjamin H Jr · Yadkinville, NCBuilt 1980 · S/N 15284384N6304LClemons Thomas · New York, NYBuilt 1971 · S/N AA1A-0304N6304MMls Aviation LLC · Yorba Linda, CABuilt 1980 · S/N 15284663
Back to AD 80-25-02 R2