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.

N8063MFriar Aerospace Group LLC · Jacksonville, FLBuilt 1978 · S/N 31-7852023N807ABSunward Aviation Services LLC · Merritt Island, FLS/N 31-8152183N808ABSunward Aviation Services LLC · Merritt Island, FLS/N 31-8052128N80GVMoro Aircraft Leasing Inc · Two Rivers, AKBuilt 1975 · S/N 31-7552003N812TBTwin Aviation LLC · Coushatta, LABuilt 1981 · S/N 31-8152113N8131Regional Air & Transport LLC · Mims, FLBuilt 1981 · S/N 31-8152032N818BRMarc Inc · Bolton, MSBuilt 1981 · S/N 318152102N81EDNav-Pete LLC · Memphis, TNBuilt 1979 · S/N 31-7952220N820FSAir Arctic Inc · Fairbanks, AKBuilt 1979 · S/N 317952185N820JHHughes Leasing Co · Miami, FLBuilt 1981 · S/N 318152015N824PGMount Olive Flight Club LLC · Mount Olive, NCBuilt 1982 · S/N 31-8252055N827RDGoyo Air LLC · Miami, FLBuilt 1976 · S/N 31-7652094N828HJPegasus Air Charter LLC · Hartford, CTBuilt 1980 · S/N 31-8052160N828KTJones Larry · Anchorage, AKBuilt 1980 · S/N 318052098N834NQAlaska Door LLC · Wasilla, AKBuilt 1977 · S/N 31-7752070N849DWCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1979 · S/N 317952070N868ETSale Reported · Eagle OranjestadSale reportedBuilt 1973 · S/N 31-7305063N86VADe Leon Inc · Perth Amboy, NJS/N 31-7952020N880RCPuerto Rico Aircraft Leasing Corp · Ceiba, PRBuilt 1973 · S/N 31-7305022N885HAFox Airways LLC · Wasilla, AKS/N 31-7405416N888JJGst Inmotion LLC · Kalispell, MTBuilt 1978 · S/N 317852078N888LMAir Mods And Repair · Robbinsville, NJS/N 31-7405464N888PCAirmonarc LLC · Orlando, FLBuilt 1981 · S/N 31-8152086N888YAAds-B Technologies LLC · Anchorage, AKS/N 31-7305076N88TGMakushin Logistics LLC · Fairbanks, AKBuilt 1984 · S/N 31-8452020N88TLAh Legacy LLC · Orlando, FLBuilt 1980 · S/N 31-8152066N88ZMFlorida Aero Services Sales Division Inc · Brandon, FLBuilt 1976 · S/N 31-7752016N890HMarc Inc · Bolton, MSBuilt 1980 · S/N 31-8052194N904SCMedical Disposables Corp · Orlando, FLBuilt 1981 · S/N 31-8152194N905TJWhittington Peter M · Jupiter, FLS/N 31-7952204N919BBAf Land Ventures LLC · Palm City, FLS/N 31-7852025N91PWAerial Imaging Inc · South Bend, INBuilt 1976 · S/N 31-7652102N9247LGenesis Aviation Enterprises Inc · Fort Lauderdale, FLS/N 31-8152160N926HBAwmr LLC · Conroe, TXBuilt 1975 · S/N 317552007N92BLIsland Birds Inc · St Thomas, VIS/N 31-7852095N931SAMarc Inc · Bolton, MSBuilt 1975 · S/N 317552036N938PMD & B Aviation LLC · Stroudsburg, PABuilt 1983 · S/N 31-8452013N942EAngry Manx LLC · Riverside, CABuilt 1975 · S/N 31-7552116N95KAAirborne Resources Inc · Midlothian, TXBuilt 1981 · S/N 318152146N95TCMmec Air LLC · Oxford, MSBuilt 1983 · S/N 31-8352037N961PAThiel Bros Roofing Inc · Sidney, MTFirst renewal noticeBuilt 1975 · S/N 317652017N96342Aircraft & Aviation Professionals LLC · Coldwater, MIBuilt 1977 · S/N 31-7405205N974CSMcgregor Daniel A · Denali Natl Park, AKBuilt 1976 · S/N 31-7652120N97MADodson International Parts Inc · Rantoul, KSBuilt 1975 · S/N 31-7552006N9901Noiw Resources LLC · Belle Chasse, LABuilt 1981 · S/N 318152168N995AKLake Clark Air Inc · Port Alsworth, AKBuilt 1977 · S/N 31-7752089N9993RCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1979 · S/N 31-8052029N999GKTaylor Craig E · Nantucket, MABuilt 1981 · S/N 31-8152101N9FWWright Air Service Inc · Fairbanks, AKBuilt 1974 · S/N 31-7405468
Back to AD 2016-08-18