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.

N6707ZHood River Soaring Inc · Hood River, ORBuilt 1963 · S/N 25-2316N6708BHartman Darrell W · Fish Lake Valley, NVBuilt 1956 · S/N 22-4041N6708NBobby Stephen M · Dunkirk, MDBuilt 1979 · S/N M-2243N6708PWest Robert S · Gravois Mills, MOBuilt 1960 · S/N 24-1834N6708RStorey Timothy J · Camarillo, CABuilt 1980 · S/N M-2244N6708SWininger Spencer C · Wichita, KSBuilt 1980 · S/N M-2245N6708UBlaedow Kyle R · Leesville, LAS/N 2440N6708XBaumbach James P · Lodi, CABuilt 1979 · S/N WA-53N6709FMorning Star Transportation Inc · Dardanelle, ARBuilt 1979 · S/N M-2247N6709LBowlin Frank J · Santa Fe, NMBuilt 1979 · S/N WA-56N6709PRzewinski Leonard · Wading River, NYBuilt 1960 · S/N 24-1835N670BBeck Mark A · Fort Wayne, INBuilt 2007 · S/N 60176N670CSSilverhawk Aviation Academy LLC · Caldwell, IDBuilt 2002 · S/N 172S9098N670EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2021 · S/N 172S12690N670LHFf22 LLC · Scottsdale, AZBuilt 2023 · S/N 2881680N670MAVan Anda Aviation LLC · Apopka, FLBuilt 1999 · S/N 17280728N670MLQualitair LLC Trustee · MichelstadtBuilt 1970 · S/N MC-65N670PWN670pw LLC · Monmouth Beach, NJBuilt 1981 · S/N 32R-8213010N670RVSokoloski Gregory · Magnolia, TXBuilt 2006 · S/N 90670N670SBDanles Enterprises LLC · Solvang, CABuilt 2001 · S/N 23806N670SCSpartan Education LLC · Tulsa, OKBuilt 2021 · S/N 2881436N670UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2024 · S/N 28020168N670WBCt Cattle Co LLC · Wichita Falls, TXBuilt 1966 · S/N 30-1053N6710BBarnard Matthew Bryan · Fort Worth, TXBuilt 1980 · S/N M-2246N6710NJohnson Kenneth W · Pine Bluff, ARBuilt 1968 · S/N 680084N6710POdell Jeffrey S · Roseville, CABuilt 1960 · S/N 24-1836N6710UMonroe Flying Club Inc · Glen Carbon, ILBuilt 1963 · S/N 2442N6710ZHeatwole Oren · Dayton, VABuilt 2017 · S/N 82060N6711Blue Heron Marine & Air LLC · Fredericksburg, TXBuilt 2009 · S/N 24135N6711BJohnson Nathaniel D · Attalla, ALBuilt 1956 · S/N 22-4044N6711GQuality Aviation Inc · Atlanta, GABuilt 1979 · S/N ME-311N6711JFirecrest LLC · Holly Springs, MSBuilt 1968 · S/N 28-24408N6711NHanna William R · Castle Rock, COBuilt 1968 · S/N 680045N6711PPietroburgo Stephen M · Colville, WABuilt 1960 · S/N 24-1837N6711RAme Flight Holdings LLC · Oasis, IDBuilt 1979 · S/N WA-60N6711UUlassin Kyle B · Corvallis, ORBuilt 1963 · S/N 2443N6711WBrinkman Michael R · Cleveland, TNBuilt 1965 · S/N 28-20824N6711ZWoolslayer Joseph Patrick · Tulsa, OKBuilt 1963 · S/N 25-2320N67123Spencer Lane Inc · Lewes, DEBuilt 1980 · S/N M-2252N6712AMcginnis Air LLC · Rising Star, TXBuilt 1980 · S/N ME-312N6712JF & F Flying Service Inc · Springfield, VAS/N 28-24410N6712USchell Kerry A · Arvada, COBuilt 1963 · S/N 2444N6712YYellowcub LLC · Billings, MTBuilt 2006 · S/N CC18-0018N67135Aviators Next Door LLC · Newnan, GAS/N M-2257N6713UHinds Casey L · Seattle, WABuilt 1963 · S/N 2445N6713VMclendon Donnie E · Winder, GABuilt 1979 · S/N WA-61N6714LBrost Bryan L · Canistota, SDBuilt 1974 · S/N 18-7409113N6714NLawler Thomas W Jr · French Lick, INBuilt 1968 · S/N 680086N6714WFriend Henry H · Hibbs, PABuilt 1965 · S/N 28-20827N6715DHargett David · San Juan, PRBuilt 1980 · S/N M-2253
Back to AD 81-18-04 R2