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.

N94LBWhetzel Russell R · Milford, NJBuilt 1994 · S/N 19029CN94LESky Path N94le LLC · Carmel, INBuilt 1993 · S/N 20776N94LJFrostenson Bobi J · Fairfield, IDBuilt 1986 · S/N 218N94MBReese Elizabeth J · Glade Park, COBuilt 2012 · S/N 1306N94MPMissouri State Highway Patrol · Jefferson City, MOBuilt 1998 · S/N 18280271N94NARegistration Pending · Northampton, MARegistration pendingS/N 2844003N94PKAshwill Gregory L Trustee · Overgaard, AZBuilt 2012 · S/N 90050N94RTRoholt Philip C · Canton, OHBuilt 2014 · S/N 1N94SBBernatz Gerald F · Highland, ILBuilt 1994 · S/N 22194N94SDKaeder Carpenter Deborah A · Inver Grove, MNBuilt 1947 · S/N 12-1711N94SJMoe Alan D · North Bend, ORBuilt 1988 · S/N 01N94SKKeen Douglas C · Munith, MIBuilt 1998 · S/N 200039N94TBMartin Robert L III · Covesville, VAFirst renewal noticeBuilt 1995 · S/N 23882N94TDKirk Tim L · Hilltop Lakes, TXBuilt 2007 · S/N 71717N94TFWildblue LLC · Edgerton, MOBuilt 1994 · S/N 3213074N94TSPetersen Andrew John · Saint Paul, MNS/N 17259814N94VFPenhorwood Joshua M · Shubuta, MSBuilt 1994 · S/N 809N94WAVidal Aviation LLC · Gaithersburg, MDS/N 2843118N94WDRegistration Pending · Sugar Grove, ILRegistration pendingS/N 1849N94WGAltruda Thomas Joseph · Las Vegas, NVBuilt 2005 · S/N 4273N94WSParker Rob · Oklahoma City, OKBuilt 1994 · S/N 3176N94WYMiller Thomas Baker · Tigrett, TNBuilt 2020 · S/N 3351N94XTaylor Samuel R · Kenai, AKBuilt 1962 · S/N 18-7858N94YCBeauchene Mark J · Des Moines, IABuilt 1965 · S/N 30-899N95005Christiansen Aviation LLC · Wilmington, DEBuilt 1984 · S/N 15285835N95008Ottaway Brent E · Derby, KSBuilt 1969 · S/N 28-25775N9500DFlight Club LLC · Anchorage, AKBuilt 1958 · S/N 22-6415N9500JMidwest Air Freight LLC · Sioux City, IABuilt 1966 · S/N 28-3620N9500LAtlantic Aero Club Inc · Newark, DEBuilt 1972 · S/N AA5-0100N9500MZoom Thusiasts LLC · Smyrna, GABuilt 1967 · S/N 670258N9500WRachel Calvin · Kimberly, ALS/N 28-22921N9501DBelof Joshua · Franklin, NCBuilt 1958 · S/N 22-6416N9501JKnutson Donald W · Litchfield, MNBuilt 1966 · S/N 28-3621N9501MCasterline Douglas J · Kansas City, MOBuilt 1966 · S/N 670078N9501WAwwad Mamdouh A · Walnut Creek, CABuilt 1997 · S/N 17280304N95021Space Coast Aircraft Co · Merritt Island, FLBuilt 1984 · S/N 15285838N9502BGraceffa Salvatore · Atascadero, CABuilt 1981 · S/N 172RG0839N9502HYoung Roger A II · Wasilla, AKFirst renewal noticeBuilt 1975 · S/N 17266182N9502MStorer Daniel A · Guthrie, OKBuilt 1966 · S/N 670079N9502WHellevang Ryan K · Duvall, WAS/N 28-22924N95031Pratt John · Anchorage, AKBuilt 1984 · S/N 15285841N9503DHardison Allan · Castle Rock, COS/N 22-6418N9503MCurell Kenneth E · Centerville, OHBuilt 1966 · S/N 670080N9503QGulf Coast Helicopters Inc · Pearland, TXS/N 18280075N9503UAom Aircraft LLC · Wilmington, DES/N 008N9503VMcdonald Michael A · Village Mills, TXBuilt 1969 · S/N 690004N9503WLoya Armando · Whittier, CAS/N 28-22925N9503YRoss Carl D · Arbuckle, CABuilt 1998 · S/N 18280215N95044Mach Point Two Aviation LLC · Conroe, TXBuilt 1969 · S/N 28-25783N9504DWilliams Jimmy Z · Sherman, TXBuilt 1958 · S/N 22-6419
Back to AD 81-18-04 R2