OpenAirDocs.org
AD 2016-13-13

Registered aircraft · 31

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-13-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:2016-13-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.

N119URegistration Pending · South Portland, MERegistration pending, canceledBuilt 1992 · S/N 259007N150LRV1vr LLC · Wilmington, DEBuilt 1996 · S/N 259050N207KSkyview LLC · Wilmington, DEBuilt 1994 · S/N 259045N261PACalla Airways LLC · Cohasset, MABuilt 1998 · S/N 259003N304BHCalla Airwaysllc · Cohasset, MAS/N NA1003N333RLJetstream Air LLC · Colfax, NCBuilt 1992 · S/N 259027N39QJAlliance Air Parts Acquisitions Corp · Oklahoma City, OKNon-citizen corporation, flight hours not reportedBuilt 1993 · S/N 259039N46WECr Aviation Inc · Miami, FLBuilt 1992 · S/N 259028N511BKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 259031N515LRAviation Dynamics LLC · South Portland, MEBuilt 1998 · S/N NA1006N520LR1489 LLC · New York, NYBuilt 1992 · S/N NA1008N520SBBank Of Utah Trustee · Salt Lake City, UTBuilt 1993 · S/N 259032N524LRUsac Airways 693 LLC · Fort Lauderdale, FLBuilt 1992 · S/N 259-024N52SMWumac Inc · South Portland, MES/N NA1009N533LRAviation Dynamics LLC · South Portland, MEBuilt 1992 · S/N 259033N541LRBank Of Utah Trustee · Salt Lake City, UTBuilt 1993 · S/N 259041N544LRAviation Dynamics LLC · South Portland, MEBuilt 1994 · S/N 259044N547LRAviation Dynamics LLC · Portland, MEBuilt 1994 · S/N 259047N548LRAviation Dynamics LLC · South Portland, MEBuilt 1995 · S/N 259048N567CLN567cl LLC · Dallas, TXBuilt 1993 · S/N 259035N600MVN767cj LLC · Williamsburg, VABuilt 1993 · S/N 259036N67WESkyview LLC · Wilmington, DEBuilt 1993 · S/N 259038N707HDEfs Aircraft Leasing LLC · North Highlands, CABuilt 1994 · S/N 259016N730CJN730cj LLC · Williamsburg, VABuilt 1992 · S/N NA1007N770RGAir Mccormack LLC · Chicago, ILBuilt 1993 · S/N 259025N800WDV1vr LLC · Wilmington, DEBuilt 1997 · S/N 259052N868WU868wu LLC · South Portland, MEBuilt 1992 · S/N 259017N880LTHawker 1000 42-51 LLC · Pompano Beach, FLBuilt 1996 · S/N 259051N8888HTexas Aircraft Parts Brokers LLC · Seguin, TXBuilt 1994 · S/N 259043N9793KDodson International Parts Inc · Rantoul, KSBuilt 1994 · S/N 259042N982ECAlliance Air Parts Acquisitions Corp · Oklahoma City, OKS/N 259005
Back to AD 2016-13-13