OpenAirDocs.org
AD 2016-05-13

Registered aircraft · 3,126

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-05-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-05-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.

N294LARoma Air Corp · Belle Glade, FLBuilt 2000 · S/N 802A-0094N294TTUncommon Solutions LLC · Hollis, NHBuilt 1984 · S/N LJ1098N295DCHibiscus26 Inc Trustee · Wilmington, DEBuilt 2000 · S/N BB-1709N295DDJds Flying Service Inc · Glen Allan, MSBuilt 2018 · S/N 602-1295N298LAGregs Crop Care Co Inc · Wilbur, WABuilt 2011 · S/N 802A-0398N299AVTeton Leasing LLC · Pocatello, IDBuilt 1999 · S/N BB-1680N299CZN299cz LLC · Milwaukee, WIBuilt 1969 · S/N U74N299MKBoman & Kemp Manufacturing Inc · Ogden, UTBuilt 1990 · S/N BB1357N299RPGuardian Flight LLC · Lewisville, TXBuilt 1996 · S/N LJ-1537N299VMSs Leasing LLC · Tulare, CABuilt 1986 · S/N LJ-1125N29ANSouth Aero Inc · Albuquerque, NMBuilt 1999 · S/N 208B0753N29MGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 208B0812N2AVRegistration Pending · Scottsdale, AZRegistration pendingBuilt 1985 · S/N 20800057N2GGN2gg Leasing LLC · Ponca City, OKBuilt 1996 · S/N BB-1539N2MKItalian Job Holdings LLC · Johnstown, OHBuilt 2003 · S/N 1063N30019O & K Aviation Inc · Newport, ARS/N T45007DCN3004WMiddle Georgia Aviation Inc · Cochran, GABuilt 1995 · S/N T42209DCN300AEColumbia Asset Trust Corp Trustee · Wichita, KSS/N 97N300BFBasler Turbo Conversions LLC · Oshkosh, WIBuilt 1943 · S/N 26744N300KAHeartland Aviation LLC · Ada, OKBuilt 1990 · S/N FL-28N300PTGjf Enterprises Inc · Port Orange, FLBuilt 1984 · S/N FA-34N300TMTaylor & Martin Enterprises Inc · Fremont, NEBuilt 1991 · S/N FL-50N300WJAthens Aviation LLC · Wilmington, DEBuilt 1977 · S/N BB-319N300WMWalker Manufacturing Co · Fort Collins, COBuilt 1988 · S/N FA156N3017ZPlane LLC (The) · Grove, OKBuilt 2013 · S/N 602-1223N301CLWin Win Aviation Inc · Wake Forest, NCBuilt 1969 · S/N 221N302PSF90x LLC · Modesto, CABuilt 1990 · S/N FA-213N3030LShannon Agricultural Flying Inc · Clarksdale, MSBuilt 2015 · S/N 802A-0602N3030QFinke Aviation LLC · Charleston, MSBuilt 2013 · S/N 802A-0509N3033HAkbj LLC · Lewes, DEBuilt 2013 · S/N 802A-0507N3038AMoss Jimmy David DBA · Tillar, ARBuilt 2013 · S/N 602-1229N30397Rust Raymond H III · Nacogdoches, TXBuilt 2003 · S/N 4697167N303GVState Of Alaska · Palmer, AKBuilt 1996 · S/N 208B0581N303JWKey Investment Holdings LLC · Horseshoe Bay, TXBuilt 2002 · S/N 4697149N303RRG2 Leasing LLC · Fargo, NDBuilt 1997 · S/N FL-178N3042SAg Aviation Inc · Muleshoe, TXBuilt 2013 · S/N 802A-0520N3044FIowa On The Fly Inc · Fonda, IABuilt 2013 · S/N 602-1231N304JSRegistration Pending · Pharr, TXRegistration pendingBuilt 1988 · S/N FA142N304SHJaimlubec LLC · Austin, TXBuilt 1986 · S/N FA-89N3051KBuilding Corp LLC · Huntsville, TXBuilt 1994 · S/N BB-1495N3052KUas Transervices Inc · Boca Raton, FLBuilt 1987 · S/N UB-70N3054WMoes Crop Dusting Service Inc · Marysville, CABuilt 2013 · S/N 802A-0525N30562J & D Aircraft LLC · Larimore, NDBuilt 2013 · S/N 602-1235N3056QPalmer Flying Service Inc · Manito, ILBuilt 2013 · S/N 802A-0535N3059NIowa On The Fly · Fonda, IABuilt 2013 · S/N 602-1236N305ELRoper Aviation LLC · Wilmington, DEBuilt 1981 · S/N BB947N3063GChristmas Flying Service LLC · Shelby, MSBuilt 2013 · S/N 802A-0529N3063YWeaver Flying Service Inc · Quincy, WABuilt 2013 · S/N 802A-0524N3065TCarroll Flying Service Inc · Lake Providence, LABuilt 2014 · S/N 602-1239N3066LBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 802A-0549
Back to AD 2016-05-13