AD 74-18-13

Registered aircraft · 1,642

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:74-18-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:74-18-13')
  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.

N8908NH & H Aviation LLC · Provo, UTBuilt 1969 · S/N 32-40695N8909NKrull Doug · Hendersonville, TNS/N 32-40696N890DFMarine Investments Llp · Morganton, NCBuilt 1978 · S/N 32-7840121N8910KCoulter Ts LLC · Midway, UTBuilt 1977 · S/N 32-7840046N8910NRam Aeronautics LLC · Wichita Falls, TXBuilt 1969 · S/N 32-40698N8914NTreetop Flyers LLC · Vashon, WABuilt 1969 · S/N 32-40704N8916NBundy Richard · Little Egg Harbor, NJBuilt 1969 · S/N 32-40707N8918NStratton Erin B · Baton Rouge, LABuilt 1969 · S/N 32-40711N8922NKew Malcolm M · Hercules, CABuilt 1969 · S/N 32-40717N8923NMiller Jarred J · Burton, OHBuilt 1969 · S/N 32-40718N8924NRobinson Andrew · Auburn, CABuilt 1969 · S/N 32-40720N8925NMackay James R · Corunna, MIS/N 32-40721N8927NHoffman Gary D · Spencer, NEFirst renewal noticeBuilt 1969 · S/N 32-40724N8937NSchewe William M · Greenville, ILFirst renewal noticeBuilt 1969 · S/N 32-40735N8939NOakley William J · Kildeer, ILBuilt 1969 · S/N 32-40741N8942NMinnema Samuel S · Fairbanks, AKS/N 32-40742N8943NChase-Six LLC · Orange Park, FLBuilt 1969 · S/N 32-40744N8947NGarfield Air LLC · Burwell, NEBuilt 1970 · S/N 32-40921N8948NC6 Flying LLC · North Logan, UTBuilt 1970 · S/N 32-40750N8950NWatson Richard D · Plant City, FLS/N 32-40751N8952CZell Zulu LLC · Greensboro, NCBuilt 1976 · S/N 32-7600010N8952NCircle K Supply Chain Solutions LLC · Knoxville, TNBuilt 1969 · S/N 32-40754N8954NSabbagh Mouin F · Missouri City, TXBuilt 1969 · S/N 32-40757N8955NRichart Nicholas J · Clever, MOBuilt 1969 · S/N 32-40758N8957NN8957n Inc · Wilmington, DEFirst renewal noticeBuilt 1969 · S/N 32-40761N8960NSkyriders Inc · Pocatello, IDBuilt 1969 · S/N 32-40771N8962NGallen Peter · Wilmington, DEBuilt 1969 · S/N 32-40773N8963NBaker Daniel T · Jackson, OHBuilt 1969 · S/N 32-40774N8966NCherokee Six LLC · Minburn, IABuilt 1969 · S/N 32-40776N8969NMatanane Roke C · Barrigada, GUBuilt 1970 · S/N 32-40769N8979NPeeling Clyde R · Allenwood, PABuilt 1969 · S/N 32-40862N8981AAmerican Aircraft Sales LLC · Lincolnshire, ILBuilt 1978 · S/N 32-7840190N8984NBlair Gary B · Salado, TXBuilt 1969 · S/N 32-40867N8986NBay Air Inc · Dillingham, AKS/N 32-40869N8988NCicero Flying Club LLC · Indianapolis, INBuilt 1969 · S/N 32-40871N898CPThomas Robert M Jr · Kissimmee, FLBuilt 1975 · S/N 32-7640031N8992NBenedict Kevin M · Lakeland, FLBuilt 1970 · S/N 32-40875N8996NBickford Shawn A · Auburn, CABuilt 1969 · S/N 32-40879N8998NHangar Cc5 LLC · Gainesville, GABuilt 1969 · S/N 32-40881N899JBInvestors Trust Co Trustee · Duncan, OKBuilt 1979 · S/N 32-7940241N89BSHalbert Consulting LLC · Enoree, SCBuilt 1979 · S/N 32-7940199N8PT10wg LLC · Newman Lake, WABuilt 1973 · S/N 32-7440024N9000MSaipan Transportation Management Solutions Inc · Saipan, MPBuilt 1971 · S/N 32-7240053N900CLThomasson Glen P · Clinton, NCBuilt 1979 · S/N 32-7940070N901BLMaritime Helicopters Inc · Homer, AKBuilt 1971 · S/N 32-7140030N90289Kuhlman Construction Company · Colesburg, IAS/N 32-7840101N9028KVan Duzer Peter John · Greenville, WIS/N 32-7840025N903HWJackson Construction Services LLC · Wichita Falls, TXBuilt 1973 · S/N 32-7340068N9089K&M Land Surveying Inc · Lincoln, NEBuilt 1966 · S/N 32-215N908DKNeilson Frank · Orlando, FLBuilt 1973 · S/N 32-7440070
Back to AD 74-18-13