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.

N964AUAuburn University · Auburn University, ALBuilt 2020 · S/N 172S12479N964CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 18282410N964DJMcculloch Randall L · Romulus, NYBuilt 1999 · S/N 0594N964EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2023 · S/N 172S13010N964GRRene Gary W · Alamo, TXBuilt 2010 · S/N 0005N964HLGraham Huber L · Gulf Breeze, FLBuilt 2001 · S/N 1N964JCIceman Air LLC · Stafford, VABuilt 1976 · S/N 22-1355N964LAHarriman Robert M Sr · Grand Isle, VTBuilt 1964 · S/N 286N964LJAir Mercury LLC · New Rochelle, NYBuilt 1997 · S/N 3246082N964LTUniversity Of La System DBA · Ruston, LABuilt 2017 · S/N 172S12034N964PLBlue Sky Industries LLC · Wilmington, DEBuilt 2004 · S/N 80315N964RGGrant Robert G · Carson City, NVBuilt 2020 · S/N 83282N964RNNoyes Randall L · Henderson, NVBuilt 1981 · S/N 964N964SEGray Luke Francis · San Bruno, CABuilt 2004 · S/N 964-2004N964SHI1 Aviation LLC · Wilmington, DEBuilt 2005 · S/N 3941N964SMMatta Sam · Houston, TXBuilt 1996 · S/N 2235N964SPDirty Side Down Aviation LLC · Georgetown, TXBuilt 1999 · S/N 172S8176N964TEBedard Robert L · Bolivar, OHBuilt 2005 · S/N 10243N964TFAir Fleet Holdings LLC · Missoula, MTBuilt 2025 · S/N 2881964N964WCStardust Aviation LLC · Farmingdale, NYBuilt 2001 · S/N 2843462N964WFTempietto Inc · Aptos, CABuilt 2003 · S/N 18281291N96503Miravete Paul Trustee · Saint George, UTBuilt 1983 · S/N 17276081N9650DKahanek Doug II · Alvarado, TXBuilt 1959 · S/N 22-6564N9650JPalmer Eric · Bowling Green, OHBuilt 1967 · S/N 28-3815N9650LKennedy Christopher D · Marlow, OKBuilt 1973 · S/N AA1B-0150N9650QVon Graff Kurt · Pennington, NJBuilt 1975 · S/N 17265734N9650UFrench James R · Eads, TNBuilt 1977 · S/N AA1C0087N9650VPittman Michael Sr · Chandler, AZBuilt 1974 · S/N 17264430N9651AMarty Air LLC · Vero Beach, FLBuilt 1950 · S/N 15481N9651DKadera David E · Dorchester, IABuilt 1959 · S/N 22-6565N9651LSmith Warren D · Oak Harbor, WABuilt 1973 · S/N AA1B-0151N9651PLedda Robert L · Soldotna, AKBuilt 1974 · S/N 18-7409142N9651RSchwartz Alan · Hurleyville, NYBuilt 1960 · S/N TD-348N9651TPilot Pros Inc · Miami, FLBuilt 1978 · S/N 38-78A0151N9651VHussain Mahmoud Taimour Said · Miami, FLBuilt 1974 · S/N 17264431N9652DWilliams Michael P · Shelburne Falls, MAS/N 22-6566N9652LLoesch William J · Saint Louis, MOBuilt 1973 · S/N AA1B-0152N9652UFry Anthony J · Rocky River, OHBuilt 1975 · S/N AA5A-0018N9652VBrown Keno · Athens, TXBuilt 1974 · S/N 17264432N9652WRegistered aircraftS/N 28-23112N9653BSd Office Supplies & Furniture Rentals LLC · Chula Vista, CABuilt 1981 · S/N 172RG0946N9653DHurt Thomas J · Kerrville, TXBuilt 1959 · S/N 22-6569N9653JClear Sky LLC · La Grange Park, ILBuilt 1966 · S/N 28-3818N9653LMahoney Anthony J · Wichita, KSBuilt 1973 · S/N AA1B-0153N9653PUhls Keith T · Austin, TXBuilt 1974 · S/N 18-7409144N9653QMikeska Rudy L · Taylor, TXBuilt 1975 · S/N 17265737N9653RColorado Northwestern Community College · Rangely, COBuilt 1960 · S/N TD-343N9653SNy Barnstormers LLC · Maine, NYBuilt 1966 · S/N 314N9653USteffen Todd M · Wind Lake, WIBuilt 1975 · S/N AA5A-0019N9653WWohl Scott D · Clarkston, WABuilt 1967 · S/N 28-23114
Back to AD 81-18-04 R2