OpenAirDocs.org
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.

N100EMKentem100 LLC · Asheboro, NCBuilt 1981 · S/N 31-8152196N100LYLyon Aviation Inc · Pittsfield, MAS/N 31-8052064N100POut Island Magic LLC · Gainesville, FLBuilt 1982 · S/N 31-8252019N100XRTomsis Corp · Panama City, FLBuilt 1981 · S/N 31-8152169N101MAPablo Air Charters LLC · New Freedom, PABuilt 1977 · S/N 31-7752186N102WHStuddiford James A · Lithia, FLS/N 31-7952066N102WMStar Air Service LLC · Jacksonville, FLBuilt 1981 · S/N 31-8152112N103BUColorado Aircraft Corp · Watkins, COS/N 31-7405202N104MQL C Whitford Co Inc · Wellsville, NYBuilt 1979 · S/N 31-7952210N106REColorado Aircraft Corp · Watkins, COS/N 31-7752056N1071AOcean Group LLC · Plantation, FLBuilt 1979 · S/N 31-7952195N108BHEmt Bahamas Holdings LLC · Greer, SCS/N 31-214N108JLStar Marianas Aviation School Inc · Saipan, MPBuilt 1983 · S/N 31-8352028N111CFGsm Tax & Insurance Inc · Naples, FLBuilt 1976 · S/N 31-7652105N111GAGeorges Aviation Services Inc · Honolulu, HIBuilt 1981 · S/N 31-8152050N111UCRcht LLC · Mason, OHBuilt 1979 · S/N 31-7952190N114NCFair Air Inc · Bloomfield Hills, MIS/N 31-8252009N114PRC W 3 LLC · San Juan, PRBuilt 1981 · S/N 31-8152088N114SACustom Air International LLC · Homestead, FLBuilt 1980 · S/N 31-8052053N1187KLove Simplicity · Princeville, HIBuilt 1980 · S/N 318052175N118MCAlpha Whiskey 3 LLC · Brandon, MSBuilt 1979 · S/N 31-7952161N120JDLamb Aviation LLC · Perris, CABuilt 1981 · S/N 31-8152179N120MLMrl Aviation LLC · Wilmington, DEBuilt 1977 · S/N 31-7752091N122AWAztec Worldwide Airlines Inc · Wilmington, DEBuilt 1976 · S/N 31-7652135N124AGPegasus Enterprises LLC · Granbury, TXBuilt 1978 · S/N 31-7852103N124WABraswell Jerrold W · Dillingham, AKS/N 31-7405242N126DRForbis Michael · Calera, OKBuilt 1974 · S/N 31-7405173N130BVTheophanis Charters LLC · Stuart, FLS/N 31-7952216N135PBD&R Holdings LLC · Kailua, HIS/N 31-7952035N135TWValiair Lc Trustee · Casper, WYS/N 31-7852001N137JHFlatspin LLC · Belle Chasse, LABuilt 1981 · S/N 31-8252025N13ALNorthstar Holdings LLC · Anchorage, AKBuilt 1976 · S/N 31-7752009N13CAAeroclub Management LLC · Cincinnati, OHBuilt 1974 · S/N 31-7405411N140RDAlpha Whiskey 3 LLC · Brandon, MSBuilt 1975 · S/N 31-7552051N141MEFox Heather J · Bettles Field, AKBuilt 1981 · S/N 31-8152117N146DCAztec Worldwide Airlines Inc · Wilmington, DES/N 31-7305109N146JMarc Inc · Bolton, MSBuilt 1977 · S/N 31-7852005N14APGlobal Air Concepts LLC · Anchorage, AKBuilt 1977 · S/N 31-7752060N151STWildman Lake Lodge Inc · Anchorage, AKBuilt 1979 · S/N 31-8052036N154WWAlpha Whiskey 1 LLC · Brandon, MSS/N 31-7952230N158JDNavajo N158jd LLC · Wilmington, DEBuilt 1981 · S/N 318152104N165TTMakushin Logistics LLC · Fairbanks, AKS/N 318452005N16YPSebastian Aero Services Inc · Guaynabo, PRBuilt 1982 · S/N 31-8252008N1872EAmerican Valet Air Inc · Wilmington, DEBuilt 1980 · S/N 31-8052114N1872HDodson International Parts Inc · Rantoul, KSBuilt 1975 · S/N 31-7652053N18HLBusinessliner Inc · Ft Lauderdale, FLBuilt 1980 · S/N 31-8052055N18RLAlpha Whiskey 3 LLC · Brandon, MSBuilt 1979 · S/N 31-7952090N196AGMarc Inc · Bolton, MSS/N 31-7952036N19CBCirrus Flying Professionals LLC · Hollywood, FLS/N 31-7752012N1ATAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1974 · S/N 31-7405478
Back to AD 2016-08-18