OpenAirDocs.org
AD 81-18-04 R2

Registered aircraft · 81,728

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.

N255CETextron Aviation Employees Flying Club Inc · Wichita, KSBuilt 2024 · S/N 18283255N255CPSierra Papa Delta LLC · Murphysboro, ILBuilt 2014 · S/N 40485N255DHMarina Electric Inc · Cutler Bay, FLBuilt 1994 · S/N 3213079N255EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2025 · S/N 172S13316N255FFry Peter J · Monument, COBuilt 2004 · S/N 3N255FLCoutts Dylan A · Windsor, MEBuilt 1998 · S/N 18280241N255JSFalcon Helicopters Inc · Logan, NMS/N 364N255KHSmith Steward Joseph · Reno, NVBuilt 1973 · S/N 327340114N255LCTrayer Jared T · Rollinsford, NHBuilt 2019 · S/N 2587N255LLChandler Elijah J S · Pilot Mountain, NCS/N 082N255MEFalbo Michael Wayne · Sellersburg, INBuilt 2000 · S/N 18280765N255PCWinger Michael J · Boulder Junction, WIBuilt 2002 · S/N 5173N255SCSouth Georgia Technical College · Americus, GABuilt 2005 · S/N 3772N255SFKcsi Aerial Patrol Inc · Bakersfield, CABuilt 2000 · S/N 1287-2000N255SKParagon Airplane Leasing Co · Fort Myers, FLBuilt 2023 · S/N 28020130N255TJackson Travels LLC · Quitman, TXBuilt 2024 · S/N 1216-2024N255TJVolar II LLC · Edmond, OKBuilt 2016 · S/N 4496394N255WAChapman Chad E · Blakely, GABuilt 2010 · S/N 40847N255WFKlapmeier Alan L · Iron River, WIBuilt 1981 · S/N R18201655N255WYWagner John W · Boise, IDBuilt 2015 · S/N 3255N255XKnop Courtney Dee · Vernal, UTS/N 20450N255ZSmall Terry A · Vernal, UTBuilt 2019 · S/N 048-171/172-544N25604Aerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1977 · S/N 15280762N25608Smith Boyd · Goshen, INBuilt 1977 · S/N 15280764N2560MAicraft Leasing LLC · Orlando, FLBuilt 1946 · S/N 12-936N2560NMcquack Aviation LLC · Belding, MIBuilt 1979 · S/N 38-79A0913N2560PBader Regan R · Saint Libory, NEBuilt 1955 · S/N 22-2923N2560WManasseh Medical Imaging Inc · Lubbock, TXS/N 924N25610Painter Bryan · Renton, WABuilt 1977 · S/N 15280766N2561WStaker Bryan P · Pleasanton, CAS/N 925N2561ZMcbride Steve · Shamong, NJBuilt 1977 · S/N 353-77N25623Pilots Choice Aviation Equipment Leasing Co · Georgetown, TXBuilt 1981 · S/N 38-81A0048N2562FMans David A · Gruver, TXBuilt 1965 · S/N 35N2562KPodany John R · Aledo, TXBuilt 1988 · S/N 922N2562MPacific Fleet Aviation LLC · Rochester, NYBuilt 1979 · S/N 27-7954078N2562UJust Plane People LLC · Irvine, CABuilt 1979 · S/N 28-8090056N2563DBeckhoff Allen C · Greybull, WYBuilt 1978 · S/N 38-79A0376N2563FHickey Michael · Honey Grove, TXBuilt 1966 · S/N 137N2563MDavidson Dan F · Ozona, TXBuilt 1946 · S/N 12-938N2563UGrande Philip M · Mt Laurel, NJBuilt 1979 · S/N 28-8090057N2564HRoberts Scott · Draper, UTS/N 002N2564MMonger Douglas J · Helena, MTBuilt 1946 · S/N 12-937N2564NKern Raymond · Bedford, INBuilt 1979 · S/N 38-79A0923N2564VMay Matthew J · Weatherford, TXBuilt 1974 · S/N 177RG0617N2564WReynolds Stuart N II · Church Road, VABuilt 1965 · S/N 3270N2565ARoggen Allen J · Caledonia, NYBuilt 1952 · S/N 22-862N2565MMacair Aviation LLC · Xenia, OHBuilt 1977 · S/N 28-7890257N2565UVintage Flyers Inc · Napa, CABuilt 1979 · S/N 28-8090058N2566MQuality Aviation Inc · Marana, AZBuilt 1946 · S/N 12-1045N2566PClark William · Easton, MOBuilt 1955 · S/N 22-2929
Back to AD 81-18-04 R2