AD 2016-08-18

Registered aircraft · 399

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

N696SGAtl Pilot LLC · Senoia, GABuilt 1984 · S/N 31-8452018N697WHAgri Enterprises LLC · Hopkinsville, KYBuilt 1983 · S/N 31-8352008N698VWSheppard Louis A · Queens Village, NYBuilt 1974 · S/N 31-7405408N6GRMarc Inc · Bolton, MSS/N 31-7752130N700CMoss Donald · Pinecrest, FLBuilt 1974 · S/N 31-7405497N709SAN709sa LLC · Maxville, FLBuilt 1983 · S/N 318352027N70FLFl Jet Services Inc · Miami Springs, FLFirst renewal noticeBuilt 1978 · S/N 31-7952030N70HHAmys Aircraft Services LLC · Bridgeton, MOBuilt 1974 · S/N 31-7405208N710DGNavajo Holdings LLC · Naples, FLS/N 31-7305017N710JPSt Matthew Aviation Company LLC · Kalispell, MTBuilt 1979 · S/N 31-7952086N711MAKiddie Hawk Air Academy · Littleton, COS/N 31-7652159N713WTWtw Air LLC · Houston, TXBuilt 1977 · S/N 31-7752138N71481Jib Inc · Groton, CTS/N 31-8352029N715AJA&J Air Sales Inc · San Antonio, TXS/N 31-7405405N7164DAir Arctic Inc · Fairbanks, AKBuilt 1980 · S/N 31-8052013N717UOcean Abaco LLC · Virginia Beach, VABuilt 1983 · S/N 31-8352026N71LKChallenge Tool & Mfg Inc · New Haven, INS/N 31-8052155N722WCS & T Aviation LLC · Missoula, MTS/N 31-8052166N723KYCommonwealth Of Kentucky · Frankfort, KYBuilt 1978 · S/N 31-7852122N725RWGalante Holdings LLC · Altamont, ILS/N 31-7952187N727MAMarc Inc · Bolton, MSBuilt 1976 · S/N 31-7652048N728CAPremiere Aviation Inc · Wilmington, DEBuilt 1976 · S/N 31-7752035N72LKN72lk Holding Company LLC · Coral Gables, FLS/N 31-8352004N73CZBm Air LLC · Anaconda, MTBuilt 1980 · S/N 31-8052177N73RTRegent Trust Corp Trustee · Wichita, KSBuilt 1982 · S/N 31-8252023N747CGAir Americus LLC · Johns Creek, GABuilt 1981 · S/N 31-8152070N74932Ruocco 220 LLC · Escondido, CABuilt 1973 · S/N 31-7305074N74972H&H Aircraft LLC · Grey Eagle, MNBuilt 1973 · S/N 31-7305123N74DDN74dd Inc · Apalachicola, FLBuilt 1978 · S/N 31-7952016N75LKN75lk LLC · Lafayette, LABuilt 1981 · S/N 31-8152173N765KPMarc Inc · Bolton, MSBuilt 1982 · S/N 31-8253012N766CFAirplane Five LLC · Miami, FLBuilt 1973 · S/N 31-7305102N7694LLowell Darryl S · Anchorage, AKBuilt 1973 · S/N 31-7305024N76JNGross Charles C III · Mims, FLBuilt 1976 · S/N 31-7652176N770KTInterprime Air Inc · Doral, FLBuilt 1975 · S/N 31-7552053N772DLClik Services LLC · Forestdale, MABuilt 1981 · S/N 318152007N776WBcww LLC · Bakersfield, CABuilt 1980 · S/N 31-8052165N777HZCb Auto Inc · Columbia, MDS/N 31-7405177N777ZMFriar Aerospace Group LLC · Dover, DEBuilt 1980 · S/N 31-8052193N7827SStar Aviation Inc · Melville, NYBuilt 1982 · S/N 31-8252035N783BZJsaz LLC · North Little Rock, ARS/N 31-7305018N787RWJw Venture Aviation LLC · Concord, NCS/N 31-7652087N78GHCustom Air International LLC · Homestead, FLBuilt 1978 · S/N 31-7852121N79LDTcb Aviation LLC · Evansville, INBuilt 1982 · S/N 31-8252062N800LPC A Aviation Corp · Clifton, TXBuilt 1983 · S/N 31-8352009N800MWNorpel Express LLC · New Bedford, MABuilt 1981 · S/N 31-8252011N801CHRisse Greg L · Lincoln, CABuilt 1974 · S/N 31-7405460N802GAMns Asset Management LLC · Dover, DEBuilt 1981 · S/N 31-8152103N8033RGoodson Aviation LLC · Tallahassee, FLS/N 31-7952065N805NJFreedom Capital Air LLC · Winchester, TNBuilt 1980 · S/N 31-8052109
Back to AD 2016-08-18