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.

N5419PTrease Marvin R · Elwood, NEBuilt 1958 · S/N 24-473N5419SAberdeen School District · Aberdeen, MSBuilt 1971 · S/N 28-7125117N541AEHodgson Jerome D · Live Oak, FLBuilt 1996 · S/N 1311N541AMSzmiot Daniel Roy · Marble, COBuilt 2001 · S/N 2153N541BSDalke Debbie R · Aumsville, ORBuilt 1980 · S/N R18201568N541CAVaughan Aviation LLC · Azle, TXBuilt 1976 · S/N 28-7790089N541CWCentral Washington University · Ellensburg, WABuilt 2018 · S/N 2881050N541DZLarson Alexis Kae · Bismarck, NDS/N 92N541ESouthern Illinois University · Murphysboro, ILBuilt 2011 · S/N 17281593N541EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2025 · S/N 172S13311N541EXScott Steven G · San Diego, CABuilt 2023 · S/N 1541SSN541GW2 Huskies LLC · Sheridan, WYBuilt 2013 · S/N 91659N541HFOpen Flight Plan LLC · Decatur, GABuilt 1973 · S/N 28R-7335335N541JBHuffman Aviation LLC · Burleson, TXBuilt 1981 · S/N R18201752N541JTThomson Jim · Emmett, IDBuilt 1998 · S/N 24884N541KSKent State University · Stow, OHBuilt 2016 · S/N 172S11671N541LCBarbers Point Flight School LLC · Kapolei, HIBuilt 2022 · S/N 172S12860N541MERegistered aircraftBuilt 2007 · S/N 1400-2007N541PPatch Philip J · Hollis Center, MEBuilt 1997 · S/N 3707N541PCLegacy Staining LLC · Monroe, GAS/N 1563N541PGHiggins Bennett P · Dedham, MEBuilt 2015 · S/N 1903N541PUEquipment Maintenance Specialists LLC · Auxvasse, MOBuilt 2003 · S/N 2844097N541RJSwostar Holdings LLC · Brookhaven, GABuilt 1978 · S/N 28-7911087N541TRegistered aircraftBuilt 2016 · S/N 2207N541WSFox Leasing Group LLC · Hollywood, FLBuilt 2003 · S/N 172S9340N54203Atlanta Aviation Academy Inc · Lawrenceville, GABuilt 1981 · S/N 17274915N54208Swain Brett L · Las Vegas, NVFirst renewal noticeBuilt 1981 · S/N 17274917N5420HChildress Bradley M · Rolling Prairie, INBuilt 1975 · S/N 17265431N5420LHughes Mormon Byrd · Rhome, TXBuilt 1974 · S/N AA5-0510N5420POklahoma State University · Stillwater, OKBuilt 1981 · S/N 15284942N5420WGade Donald A · Antioch, ILS/N 28-491N5420ZAthey Jeff R · Friendswood, TXBuilt 1961 · S/N 22-9193N54214Halo Aviation Texas LLC · Fredericksburg, TXBuilt 1981 · S/N 17274922N54219Kleb John S · Aurora, ILBuilt 1981 · S/N 17274925N5421KWings Over Texas Holdings LLC · Denton, TXS/N 17274104N5421LStanfill Michael O · Lucedale, MSS/N AA5-0321N5421PRiverside Flight Center Inc · Tulsa, OKBuilt 1981 · S/N 15284943N5421SAmeriflyers Of Texas Inc · Addison, TXBuilt 1999 · S/N 172S8080N5421WBrown David A · Olympia, WAFirst renewal noticeBuilt 1962 · S/N 28-492N54223Woodworth Brent J · Halliday, NDBuilt 1976 · S/N 18-7609045N5422QMandeville James R · Bridgewater, MABuilt 1989 · S/N 111N5422SVanwagnen Brian J · Jackson, MIBuilt 1971 · S/N 28-7125118N54233Wenke Donald S · Big Lake, AKBuilt 1976 · S/N 18-7609047N5423ESkywarrior Flight Training LLC · Pensacola, FLBuilt 1978 · S/N 17271854N5423JRialto Christian Flyers Club Inc · Bradenton, FLBuilt 1980 · S/N 17273787N5423KRandel James B III · Mill Valley, CABuilt 1980 · S/N 17274105N5423PPapp Frank J · Fort Mohave, AZBuilt 1959 · S/N 24-477N5423ZBergstrom Lindsay B · Plymouth, MNS/N 22-9197N54247Registration Pending · Melbourne, FLRegistration pendingBuilt 1976 · S/N 18-7609049N5424JFusano Lisa A · La Crescenta, CABuilt 1980 · S/N 17273788
Back to AD 81-18-04 R2