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.

N82EBBogner Edward R Trustee · Santa Cruz, CABuilt 1978 · S/N 32R-7985028N82EJJw Flyers LLC · Allen, TXBuilt 1976 · S/N AA5B-0234N82EPPosav Holdings LLC · Zephyrhills, FLBuilt 1978 · S/N 17271353N82ERMidwest Airmotive Inc · Mount Sterling, KYBuilt 1978 · S/N R18200225N82EZFloyd Allen T · Erie, COBuilt 2015 · S/N 82N82FMF J Corporation · Wilmington, DEBuilt 1999 · S/N 80834N82FYBurbage Richard W · Wichita Falls, TXBuilt 2009 · S/N 82302N82GCVolk James E · Argyle, TXBuilt 2004 · S/N 60545N82GHMorrison Richard L · Lake Como, FLBuilt 1982 · S/N 1N82HABeller Ronald D · Morehead, KYBuilt 1976 · S/N 17702401N82HUOpatril Ron · Creede, COBuilt 2025 · S/N 3454N82HYJohnson Michael T · Moatsville, WVBuilt 2002 · S/N 2191N82JStewart Michael W · Snellville, GAS/N JH111N82JDJ D Aviation LLC · Rochester, NYBuilt 2018 · S/N 18283040N82JNNicholas Kim A · Kent, WABuilt 2004 · S/N 90150N82KCDrake Raymond H · Asheville, NCBuilt 1998 · S/N 18280193N82KDKizita Management LLC · Los Altos, CABuilt 2019 · S/N 1182-2019N82KLMcdaniel Michael Ray · Hampton Cove, ALBuilt 1977 · S/N 24-0280N82KMShartle Austin W · Fredericksburg, PABuilt 1988 · S/N KM-02N82KPCarter Doug A · Tower, MNBuilt 2024 · S/N 318RN82LAAvery Lyle · Beach Lake, PABuilt 2000 · S/N 18280846N82LECollier County Sheriffs Office · Naples, FLBuilt 2004 · S/N 18281377N82LMMartindale Harold L · Orange, TXBuilt 1984 · S/N 1215N82LRKristoferson John S · Denton, TXBuilt 1990 · S/N 82N82LTRegistered aircraftBuilt 2005 · S/N 172S9913N82MReady Aim Flyer LLC · New Castle, DEBuilt 1958 · S/N TD-167N82MHRainier Flight Service LLC · Renton, WABuilt 2023 · S/N 172S13002N82MTMalo Blake Ridgway Trustee · Portland, ORBuilt 2017 · S/N 004N82NBMohillsmith Coulter · Temecula, CABuilt 2000 · S/N 001N82NDBaker David Jr · Louisville, KYS/N 0140N82NFN82nf LLC · Mckinney, TXBuilt 2013 · S/N 3188N82PDJames Gary S · Weatherford, TXBuilt 1984 · S/N PD1N82PLOilar Agricultural Services · Mcarthur, CABuilt 2008 · S/N 3047N82PMCollings Foundation Inc · Hudson, MABuilt 1976 · S/N AA5B-0250N82RRegistered aircraftS/N 24564N82RBBurns Robert A · Fort Myers, FLS/N 3524N82RCShackelford John S Jr · Roanoke, TXS/N 0-540-2N82RDStrafford Cameron Cornell · San Diego, CAS/N 001N82RHHolte Brian J · Monticello, MNS/N 1-0003N82RJLynch James D Jr · Ocala, FLBuilt 1966 · S/N 30-1049N82RRCramp Steven J · Cleveland, TXS/N 001N82STStumpf Blain · Placerville, CABuilt 2017 · S/N 83362N82TDSharpe Andrew M · Wildwood, MOBuilt 2024 · S/N 81150N82THBirrell Christopher James · Ottumwa, IABuilt 1999 · S/N 2042N82TTJaconetti William J · Saint Peters, MOS/N 616N82VBSky Designs LLC · Kalamazoo, MIBuilt 1967 · S/N 491N82VWHeiman Caleb R · Summerfield, KSBuilt 2004 · S/N 23758N82WGHash Brian Morrison · Mattawa, WABuilt 1998 · S/N 18280388N82WHReed Joshua · Chesapeake, VABuilt 1981 · S/N 32R-8213026N82WKFarnum Kelly S · Midlothian, TXBuilt 2004 · S/N 60532
Back to AD 81-18-04 R2