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.

N65413John Mccaskill Enterprises LLC · Tifton, GAS/N 18281444N65415Cal Aggie Flying Farmers Inc · Davis, CABuilt 1978 · S/N 15281537N65417Frear Robert · N Redngtn Bch, FLBuilt 1978 · S/N 15281539N6541LOse Leroy B · Thief River Falls, MNBuilt 1973 · S/N AA1B-0341N6541URegistered aircraftBuilt 1962 · S/N 2324N6542HOwens Flight Training LLC · Lafayette, LABuilt 1975 · S/N 17265482N6542PSmith Noland F Jr · Chattanooga, TNBuilt 1959 · S/N 24-1664N6542VHarris Dakota · Goose Creek, SCBuilt 1980 · S/N 172RG0765N6542WBaird Philip D · Judith Gap, MTS/N 28-21268N6542ZKingsley Kiman J · Miller, MOBuilt 1962 · S/N 25-2081N65435Wings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15281550N65439Pnl Aero LLC · Raleigh, NCBuilt 1981 · S/N 15285287N6543DBatte Randall E · Forest, MSBuilt 1979 · S/N 17272855N6543UGiesey William · Philadelphia, PABuilt 1962 · S/N 2326N6543VChupito Sabrocito LLC · Paso Robles, CABuilt 1980 · S/N 172RG0766N6543WJts Aircraft LLC · Rock Hill, SCBuilt 1965 · S/N 28-20622N65440G&M Aircraft Inc · Wheat Ridge, COBuilt 1978 · S/N 15281554N65447Maxxum Financial Group Inc · Destrehan, LABuilt 2004 · S/N 172S9712N65449Hoeft Cliff A · Pilot Rock, ORBuilt 1978 · S/N 15281557N6544AMatthews Aviation LLC · Hardinsburg, KYS/N 27-7954005N6544KWaldron Ronald J · Strongsville, OHBuilt 1980 · S/N 17274209N6544LPencoe Glenn L · Jemison, ALBuilt 1974 · S/N AA1B-0344N6544TCourtney John T · Woodbridge, CTBuilt 1968 · S/N MB-365N6544WBrown Rayford K · Temple, TXBuilt 1990 · S/N 436N6545365453 LLC · Blaine, MNBuilt 2004 · S/N 172S9717N6545DCosta Flying Service Inc · Painted Post, NYBuilt 1979 · S/N 17272856N6545GBoomer Aviation Inc · Fort Walton Beach, FLBuilt 1971 · S/N 15072045N6545HAmerican Patrols Inc · Midland, TXBuilt 1975 · S/N 17265483N6545RBonilla-Cruz Carlos · Houston, TXBuilt 1974 · S/N M-1581N65468Burger John J · Ocala, FLBuilt 1978 · S/N 15281569N6546FMiljour Jack A · Sanborn, NYBuilt 1976 · S/N 28-7790153N6546UBadlands Flyers Inc · Watford City, NDBuilt 1962 · S/N 2329N65470Jt Aero LLC · Wilmington, DEBuilt 1978 · S/N 15281570N65471Overland Aviation LLC · Williston, NDBuilt 2004 · S/N 172S9718N65472Registered aircraftBuilt 2004 · S/N 18281451N6547JMeyer Mark A · Vass, NCBuilt 1968 · S/N 28-4990N6547SMiller Bradley J · Joliet, MTS/N 15067347N6547WMacclements Jonathan E · Austin, TXBuilt 1965 · S/N 28-20626N65483American Aviation Inc · Brooksville, FLS/N 15281580N65489Flight Solutions LLC · Columbia, MOBuilt 1982 · S/N 17275762N6548ESewell William G Jr · Bremen, GABuilt 1978 · S/N 17272036N6548JInspire Aviation LLC · Magnolia, TXBuilt 1968 · S/N 28-4992N6548LJudge Christopher E · Vacaville, CABuilt 1974 · S/N AA1B-0348N6548PPettus Gary A · Fort Mill, SCS/N 24-1670N6548VMaxwell Frank R · Fairbanks, AKBuilt 1980 · S/N 172RG0771N6548ZKingsley Kiman J · Miller, MOBuilt 1962 · S/N 25-2090N65495Circle W Flying Club Inc · Creighton, PABuilt 1978 · S/N 15281587N65498Wings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15281588N65499Pacific Quality Controls Inc · Wrightwood, CABuilt 2004 · S/N 172S9720N6549DBbjs Investments LLC · Waukesha, WIBuilt 1979 · S/N 17272858
Back to AD 81-18-04 R2