AD 81-18-04 R2

Registered aircraft · 81,733

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:81-18-04-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:81-18-04-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.

N7257QSmith Henry C III · Essexville, MIBuilt 1972 · S/N 17260557N7257TJet & Rotor Aviation LLC · Sacramento, CABuilt 1999 · S/N 17280787N7257UReim Rodney D · Enid, OKBuilt 2019 · S/N 7257N7257YRice Clark D · Anaconda, MTFirst renewal noticeBuilt 1964 · S/N 30-290N7257ZPrivate Pilot Aircraft Rentals LLC · Sanibel, FLBuilt 1999 · S/N 17280783N7258International Air Services Inc Trustee · Carson City, NVBuilt 1980 · S/N 172RG-0508N72588Seidel Roland · Azle, TXBuilt 1963 · S/N TD-532N7258CRegistered aircraftBuilt 1975 · S/N 28-7690063N7258DVandemerwe Rilyn Grant · Durango, COBuilt 1957 · S/N 22-5085N7258FCochran Brent D · Sandy Valley, NVBuilt 1968 · S/N 28-25177N7258YJprg Aviation Inc · Orlando, FLBuilt 1964 · S/N 30-291N7259CN7259c LLC · Indianapolis, INBuilt 1975 · S/N 28-7690064N7259FLearn 2 Fly Ct LLC · Simsbury, CTBuilt 1976 · S/N 28-7715205N7259KLavigne Richard P · Ranier, MNBuilt 1950 · S/N 18-153N7259LDella Ripa Vincenzo · Newbury Park, CABuilt 1972 · S/N AA1A-0459N7259QForbes Gregory Allan · Lowell, MIBuilt 1972 · S/N 17260559N725AN725a LLC · Manassas, VABuilt 2000 · S/N 0105N725ACFiorini Jay · Turlock, CABuilt 1999 · S/N 1254-98N725BBScenic Concepts LLC · La Crosse, WIBuilt 1976 · S/N 17267802N725BJBas Part Sales LLC · Greeley, COS/N 20608023N725BKAmerican Patrols Inc · Midland, TXBuilt 1971 · S/N 17259821N725CAScaled Vantage LLC · Olathe, KSBuilt 2024 · S/N 41935N725CBRenner David M · Longview, WABuilt 2003 · S/N 884N725CMScholz Mark W · Atchison, KSBuilt 1997 · S/N 794-97N725DBMang Joseph K · West Des Moines, IABuilt 1976 · S/N AA5A-0126N725DGRed Pine Exploration & Research LLC · Boca Raton, FLBuilt 1977 · S/N 32-7840032N725ECDraco Flight School Inc · Chino, CABuilt 1972 · S/N 17260842N725ESKovasckitz Michael J · Cincinnati, OHBuilt 2003 · S/N 25629N725GALendor David A · Jersey City, NJBuilt 1978 · S/N GA7-0024N725GMPyke Gregory A · Graham, WABuilt 2014 · S/N 1001N725HEOtt Edward C · Walnut Creek, CABuilt 2000 · S/N 441-2000N725JKAlkay Flight LLC · Lewes, DEBuilt 1988 · S/N 7480CN725JMRegistered aircraftBuilt 1997 · S/N 798-97N725LULiberty University Inc · Lynchburg, VABuilt 2024 · S/N 172S13209N725LVAia Echo LLC · Henderson, NVBuilt 2021 · S/N 172S12748N725MBBuchanan Mark W · Conroe, TXBuilt 2019 · S/N 20415N725NDUniversity Of North Dakota · Grand Forks, NDBuilt 2023 · S/N 2881620N725PGPoplar Grove Airmotive Inc · Poplar Grove, ILBuilt 1998 · S/N 172S8009N725RJWilliams Sol F · Jacksonville, FLBuilt 1971 · S/N 17260254N725RVEmery Marilyn Laverne · Randle, WABuilt 1987 · S/N 725N725SMS&M Aviation LLC · South Boston, VABuilt 2000 · S/N 0754N725SSInternational Air Services Inc Trustee · Carson City, NVBuilt 2018 · S/N 0814N725YPMilton John L · Heathsville, VABuilt 2000 · S/N 25064CN725ZNLaramie Flying Club Inc · Laramie, WYBuilt 1979 · S/N 17272734N726Veerhusen Daniel F · Homer, AKS/N 18-8309021N7260FRandy'S Rodz LLC · Missoula, MTBuilt 1968 · S/N 28-25178N7260HN2617f LLC · Frankfort, KYBuilt 2000 · S/N 18280896N7260LMincy Aviation LLC · Manistee, MIBuilt 1972 · S/N AA1A-0460N7260PPotts Leah Marie · Roanoke, VABuilt 1961 · S/N 24-2436N7260QNaples Flying Club Inc · Naples, FLBuilt 2001 · S/N 18280957
Back to AD 81-18-04 R2