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.

N266SHDirty Bird Helicopters LLC · Boerne, TXBuilt 2007 · S/N 4230N266SPTfs Air LLC · Loveland, COBuilt 2003 · S/N 172S9471N266SWWeddle Scott M Trustee · Albany, ORBuilt 2003 · S/N 70266N266WBBell W Douglas · Grand Haven, MIBuilt 2004 · S/N 80889N266WYReps R1 Drive Unit Co LLC · Helena, MTBuilt 2016 · S/N 3266N266YHogg James R · New Albany, OHBuilt 1968 · S/N 18PN26708Flying Chester Cheetah LLC · Valdosta, GABuilt 1978 · S/N AA5A0665N26713N26713 LLC · Gainesville, GAS/N AA5A0668N26715Gulfstream Aerospace Corp · Savannah, GABuilt 1978 · S/N AA5A0670N26717Dumpling Girls LLC · Concord, NCBuilt 1978 · S/N AA5A0671N26718Owen James T · Broken Arrow, OKS/N AA5A0673N2671GAas LLC · Ovid, MIBuilt 1967 · S/N 316N2671MZoch Lori R · Port Orange, FLBuilt 1946 · S/N 12-972N2671WSchwister Daniel Edward · Woodinville, WABuilt 1966 · S/N 3315N26722Neutren Glenn · Fort Bragg, CABuilt 1978 · S/N AA5A0675N26723Fulcrum Software Corp · Raleigh, NCBuilt 1978 · S/N AA5A0676N26725Registered aircraftS/N AA5A0678N26728Schmicker Robert A · Edmond, OKBuilt 1978 · S/N AA5A0680N2672Q4m Aviation LLC · Orting, WABuilt 1977 · S/N 28R-7737040N2672VWhite Robe · Castro Valley, CABuilt 1974 · S/N 177RG0649N2672WGallatin Aviation Enthusiasts LLC · Fairbanks, AKBuilt 1966 · S/N 3316N2672XBird Nest Aviation LLC · Sheldon, IABuilt 1998 · S/N 18280305N2672ZPuma Applied Science · Winchester, CABuilt 1977 · S/N 1007-78N26733Givens Eric J · Frankfort, OHBuilt 1978 · S/N AA5A0605N26737Noser Thomas C · Bowling Green, KYBuilt 1978 · S/N AA5A0683N26738Hardy David G · Gilbert, SCBuilt 1978 · S/N AA5A0684N2673AWilde Air Service LLC · Volga, SDBuilt 1953 · S/N 22-933N2673TZweig William D · Chesterfield, MOBuilt 1972 · S/N 28-E11N2673VJackson R N · Southlake, TXBuilt 1974 · S/N 177RG0650N2673WAdolf Charles P · Ocala, FLBuilt 1966 · S/N 996N26743Lian Jay · Gold Beach, ORBuilt 1978 · S/N AA5A0686N26744Flying Tigers Flight School Ltd · Houston, TXBuilt 1978 · S/N AA5A0688N2674MStarr LLC · Superior, WIBuilt 1946 · S/N 12-1107N2674TCosgrove John W · Lake Ariel, PABuilt 1971 · S/N 28-7205075N2674VMoroil Corp · Davidson, NCBuilt 1974 · S/N 177RG0651N2674WHough Publishing LLC · Atlanta, GABuilt 1966 · S/N 997N26757Terranova Jay · Lawrenceville, GAS/N AA5A0695N26758Cooley Carolyn A · Bonifay, FLBuilt 1978 · S/N AA5A0696N2675DPaige Barry Wayne · Wasilla, AKBuilt 1952 · S/N 20827N2675TMahoney Dustin G · Lakewood, COBuilt 1971 · S/N 28-7225084N26760Davis Dana J · Pismo Beach, CABuilt 1978 · S/N AA5A0699N26768Cheetah268 LLC · Kailua Kona, HIBuilt 1978 · S/N AA5A0704N2676TMills Nicolas A · Greenwood, NYBuilt 1971 · S/N 28-7205074N2676ZFlynn Steven W · Bushnell, FLBuilt 1977 · S/N 1008-78N26770Tuan Vo · Falls Church, VABuilt 1978 · S/N AA5A0705N26778N26778 LLC · Santa Monica, CABuilt 1978 · S/N AA5A0714N2677ML & L Farms · Richvale, CABuilt 1946 · S/N 12-1095N2677TDaggett Truck Lines Inc · Frazee, MNBuilt 1971 · S/N 28-7205077N2677WSaunders Charles A · Scott Depot, WVBuilt 1966 · S/N 3318N2677ZWillkris Aviation Services LLC · Smithfield, VAS/N 1018-78
Back to AD 81-18-04 R2