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.

N757XWPittsburgh Institute Of Aeronautics · West Mifflin, PABuilt 1977 · S/N 15280095N757YARule John D · Nampa, IDS/N 15280099N757YMDarcy Aviation LLC · Danbury, CTS/N 15280110N757YSJohn Mccaskill Enterprises LLC · Tifton, GABuilt 1977 · S/N 15280115N757YUTechnical Education Services Inc T/A · Virginia Beach, VABuilt 1977 · S/N 15280117N757ZKodysh Peter J · North Ridgeville, OHBuilt 2000 · S/N 863N757ZAAdventure Flight Aviation Inc · Springdale, ARBuilt 1977 · S/N 15280123N757ZNJin Jin Aviation LLC · Anchorage, AKBuilt 1977 · S/N 15280135N757ZRBishops' Ltd · Virginia Beach, VABuilt 1977 · S/N 15280138N757ZSDevereaux Mishelle · Raleigh, NCBuilt 1977 · S/N 15280139N757ZTRiya Aviation LLC · Tracy, CABuilt 1977 · S/N 15280140N7580FLybbert Randal Lorin · Moses Lake, WAS/N 736-70N7580HFurjesi Steve J · Chehalis, WABuilt 1946 · S/N 12-460N7580KCrop Care By Air Inc · Lantry, SDBuilt 1950 · S/N 18-297N7581DAllen Stephen W · Fredericksburg, TXBuilt 1957 · S/N 18-5875N7581HMartinez Anthony III · Great Bend, KSBuilt 1946 · S/N 12-451N7581KU Lazy S Ranch · Post, TXBuilt 1950 · S/N 18-298N7583FDienst Lon C · Poplar Grove, ILBuilt 1970 · S/N 739-70N7585HJordan Don T · Midlothian, TXBuilt 1946 · S/N 12-465N7586FJh Aviation Services LLC · Daisy, GABuilt 1970 · S/N 742-70N7588FWilbanks Kari L · North Port, FLBuilt 1970 · S/N 751-70N7588HEagy Gregory L · Boise, IDBuilt 1946 · S/N 12-450N758PANew Horizons Aviation Inc · Goshen, INBuilt 1978 · S/N 15282932N758YSFly Sky Ads LLC · Manalapan, NJBuilt 1982 · S/N A1521017N758YTMountain Air Flying LLC · Brigham City, UTBuilt 1982 · S/N A1521018N7592HClaypool Kimberly A · Ottumwa, IABuilt 1946 · S/N 12-466N7593HFricks Philip B · Piedmont, SCBuilt 1946 · S/N 12-467N7595HKnutson Daniel T · Lodi, WIBuilt 1946 · S/N 12-469N7597FKnowles Ross Martin · Chapmanville, WVS/N 743-70N7598FDoggett Jacob R · Kingwood, TXS/N 744-70N7599FN7599f LLC · Camarillo, CABuilt 1970 · S/N 745-70N7599HMorris Sid · Kenai, AKBuilt 1946 · S/N 12-473N7599KSimmons Dawson L Jr · Council, NCBuilt 1950 · S/N 18-316N75PLMccombs John W · Fairfax, VABuilt 1975 · S/N 113N75WRIngram William R Trustee · San Diego, CABuilt 1990 · S/N 75N7602FPreston Aviation LLC · Mount Dora, FLBuilt 1970 · S/N 755-70N7603FJacobs Robert A · Grass Valley, CABuilt 1970 · S/N 756-70N7603HRegistered aircraftN-number assigned, not yet registeredS/N 12-478N76048Larson Lee · Yuma, AZS/N 10442N7607LMeyer Maria S · New Fairfield, CTBuilt 1978 · S/N A1520825N7608HKavanagh Preston B · Tarpon Springs, FLBuilt 1946 · S/N 12-483N7611HVezina Robert J · Rockford, MIBuilt 1946 · S/N 12-487N7611USchmitt Matthew A · Kenosha, WIBuilt 1967 · S/N 101SN7614HCommand Aire LLC · Sitka, AKBuilt 1946 · S/N 12-489N7616HDahmes Brad M · Hawick, MNBuilt 1946 · S/N 12-491N7617HGarcia Roberto P · Spring Hill, FLFirst renewal noticeBuilt 1946 · S/N 12-492N761ESCronsell Kenneth L · Hampshire, ILBuilt 1980 · S/N A1520947N761FGWilliams Glenn D · Columbus, GABuilt 1980 · S/N A1520949N761GGChocks Away Aviaton LLC · Redmond, ORBuilt 1980 · S/N A1520951N761UAFirst Wings LLC · Sayre, PAS/N A1520986
Back to AD 80-25-02 R2