AD 2017-20-01

Registered aircraft · 341

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

N31ZVEzair International Leasing And Management Inc · Wilmington, DEBuilt 1996 · S/N 127N320EJAlliance Aviation Group LLC · Wilmington, DEBuilt 2001 · S/N 258523N321MSTaughannock Aviation Corp · Ithaca, NYBuilt 2001 · S/N 258515N325EXFalcon 325 LLC · Fort Pierce, FLBuilt 2002 · S/N 325N327GALmi LLC · Alpharetta, GABuilt 2005 · S/N 157N328JLLamon Aviation LLC · Boise, IDBuilt 1996 · S/N 157N331JVBoulder Falcon LLC · Salt Lake City, UTS/N 219N331USN331us LLC · Hillsboro, ORBuilt 2000 · S/N 196N333DLD&S Aircraft LLC · Chicago, ILBuilt 1997 · S/N 163N333PCSemanik Investment Corp · Jacksonville, FLBuilt 2004 · S/N 258669N33612Pmdg Flight Operations LLC · Alexandria, VABuilt 1989 · S/N 196N343WTPhantom Phlyers LLC · Pearland, TXBuilt 1986 · S/N 633911N345BHTb Equico LLC · Houston, TXBuilt 2000 · S/N 100N352CKKalitta Charters LLC · Ypsilanti, MIBuilt 1980 · S/N 313N355UALopez Fabio A · Denver, NCBuilt 1984 · S/N 114N373DGAttorney Aviation LLC · Dallas, TXBuilt 2001 · S/N 159N375RC2022 Olivia Av LLC · Austin, TXBuilt 2001 · S/N 258565N383MCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 322N383MVN383mv LLC · Amarillo, TXBuilt 1999 · S/N 258403N383TKThk Holdings LLC · Cincinnati, OHBuilt 2004 · S/N 258700N387TSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1997 · S/N 018N388BBPw Transport LLC · Lafayette, LABuilt 1999 · S/N 281N38MGBay Venture Management LLC · Atlanta, GABuilt 1989 · S/N 009N395HEBillron LLC · Houston, TXBuilt 1992 · S/N 228N400GSGreen Savoree Transportation LLC · Carmel, INBuilt 2001 · S/N 134N404FZBogey Bird II Inc · Jeffersonville, INBuilt 1985 · S/N 473N406TMAlcyone Trust Corp Trustee · Wichita, KSBuilt 2002 · S/N 258578N40BGAlliance Air Parts Acquisitions Corp · Oklahoma City, OKNon-citizen corporation, flight hours not reportedBuilt 2005 · S/N 2041N40GPBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 45-2061N411SCRegistered aircraftBuilt 2004 · S/N 258653N412SWThunderforce Investments LLC · Washington, DCBuilt 2002 · S/N 238N413VLFalcon Vl LLC · Wilmington, DEBuilt 2006 · S/N 345N417TMCpj2 LLC · Garden City, NYBuilt 2004 · S/N 258657N424TGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 169N428DRMaverick Air II LLC · Deer Park, WABuilt 2005 · S/N 154N42JJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 258509N4343FFrenkel Tardis Development Corp LLC · Dallas, TXBuilt 2003 · S/N 258641N43MFMed Flight Air Ambulance Inc · Albuquerque, NMBuilt 1980 · S/N 284N43TPAircraft Holding Solutions LLC Trustee · Newark, DES/N 258628N440GPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 85N440WPBbft Aero Holdings LLC · Columbus, OHBuilt 2001 · S/N 258524N445NAirblue Eagle Inc · Houston, TXBuilt 2002 · S/N 202N44MBTria Entertainment LLC · Wisconsin Dells, WIBuilt 2002 · S/N 258573N44VPGable S Corp · West Linn, ORBuilt 2002 · S/N 115N450TJJaco Oil Co · Bakersfield, CABuilt 1998 · S/N 012N451SJTexas Mna LLC · Westlake, TXBuilt 2001 · S/N 173N452CFHangar LLC · Las Vegas, NVBuilt 1982 · S/N 104N453AMN543am LLC · Englewood, COBuilt 1982 · S/N 453N454MFCpc Aviation LLC · Bellaire, TXBuilt 2002 · S/N 201N455DGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 129
Back to AD 2017-20-01