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.

N914TCSpeed Racer LLC · Port Orange, FLBuilt 2013 · S/N 087N914WYAcro Crazy LLC · Plymouth, MABuilt 2024 · S/N 3434N914ZSkylens LLC · Hammond, LABuilt 1974 · S/N 17264444N91507Eagle Aviation LLC · Spearfish, SDBuilt 1973 · S/N 17261499N9150DFitzgerald Larry · Fairbanks, AKBuilt 1958 · S/N 18-6540N9150HN9150h LLC · Charleston, SCBuilt 1975 · S/N 17265975N9150VUrness John · Oakland, CABuilt 1969 · S/N 690038N9150WMcmullin Chad D · Roosevelt, UTS/N 28-10777N9150YTyler Transport LLC · Troy, ALBuilt 1985 · S/N 32R-8513009N91518Hatfield Timothy E · Parowan, UTBuilt 1996 · S/N 3121N9151HFirst Flight Corp · San Diego, CABuilt 1975 · S/N 17265976N9151LCerrato Michael J · Dublin, OHBuilt 1971 · S/N 306-71N9151NPlane Nonsense Inc · Middletown, DEBuilt 1988 · S/N 2890090N9151VNeret Michael G · Sugarland, TXBuilt 1969 · S/N 690031N9151YRegistration Pending · South Jordan, UTRegistration pendingBuilt 1995 · S/N 24-3366N9152KHangar 9 Inc · Aberdeen, SDBuilt 1976 · S/N 28-7615179N9152LBaker Glen M · El Reno, OKBuilt 1971 · S/N 810-71N9152SHomer Mark · Grosse Ile, MIBuilt 1975 · S/N MC-399N9152WTeal Water Investments LLC · Blanco, TXBuilt 1966 · S/N 28-10784N9153CPax Enterprises Inc · Allen, TXBuilt 1978 · S/N R18200425N9153HSambriski Michael Daniel III · Long Beach, NYBuilt 1975 · S/N 17265978N9153JRamer Kristina · Ruskin, FLBuilt 1988 · S/N 2811021N9153SB Squared Inc · Bedford, NHBuilt 1976 · S/N MC-400N9153VRegistered aircraftBuilt 1969 · S/N 690027N91544Piper Aircraft Inc · Vero Beach, FLBuilt 1981 · S/N 38-82A0050N9154PSloan James M Trustee · Grandbury, TXBuilt 1966 · S/N 24-4640N9154YNolan Daniel R · Wilmington, NCBuilt 2001 · S/N 18280971N91553Simpson Josiah J L Trustee · Shelburne, MABuilt 1973 · S/N 17261500N9155CN9155c LLC · Palm Harbor, FLBuilt 1978 · S/N R18200427N9155DTaylor Glenn Maurice · Fayetteville, GABuilt 1958 · S/N 22-6207N9155VHickox Joseph C · Rollins, MTBuilt 1969 · S/N 690032N9155WWiger Theodore L · Falcon Heights, MNBuilt 1966 · S/N 28-10787N9156DTalmadge Jeffery K · New Milford, CTBuilt 1958 · S/N 22-6208N9156HSolar Flying Club · Grimes, IABuilt 1975 · S/N 17265981N9156JChristian Family Fellowship · Mesa, AZS/N 28-3213N9156SStickley Harold R · Wauseon, OHBuilt 1976 · S/N MC-401N9156VLegnaioli Richard · Cambridge, MDS/N 690013N9157A9k Air LLC · Newark, DEBuilt 2021 · S/N 172S12755N9157CAims Community College · Greeley, COBuilt 1978 · S/N R18200429N9157EWillard James L · Prosser, WABuilt 1977 · S/N 7114CN9157WFear David L · Hartford City, INBuilt 1966 · S/N 28-10773N9158CSmith Robert A · Stillwater, OKBuilt 1978 · S/N R18200430N9158E7 J Aeroflight Publications Inc · Gruver, TXBuilt 1977 · S/N 7115CN9158HParrish Aviation Flight Academy LLC · Southlake, TXBuilt 1975 · S/N 17265982N9158VMellinger David S · Lusby, MDBuilt 1969 · S/N 690040N9158WKirkhoff Robert A · Pottstown, PABuilt 1966 · S/N 28-10832N9158YLockwood Rick I · Garden Grove, CAS/N 18-8911N91596West Michigan Flying Club Inc · Norton Shores, MIBuilt 1973 · S/N 17261505N9159HHess Garrett · Fullerton, CAS/N 17265983N9159KRoss Andrew · Yamhill, ORBuilt 1976 · S/N 28R-7635223
Back to AD 81-18-04 R2