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.

N6180UParrish Aerial Services LLC · Wilmington, DEBuilt 1996 · S/N 502B-0390N6181QPioneer Agviation 2 LLC · Holdrege, NEBuilt 1996 · S/N 502B-0395N6182AA&R Air Inc · Hinsdale, ILBuilt 1994 · S/N BB-1484N618JCMclean Aviation Services Inc · Napa, CABuilt 2005 · S/N 618N618LAMiles Flying Service Inc · Bono, ARBuilt 2019 · S/N 802-0818N618MAAir Matrix LLC · Lomita, CABuilt 2005 · S/N 4697218N618SLewis Aeronautical LLC · San Antonio, TXS/N 618N619LAArg Aviation LLC · Lexa, ARS/N 802-0221N619PAPafford Air Of Mississippi LLC · Ruston, LABuilt 1993 · S/N BB-1458N619PFDel Ag Aero LLC · Milton, DEBuilt 2015 · S/N 802A-0619N619TKRegistered aircraftBuilt 2006 · S/N 4697243N61DJBlack Badge Aviation LLC · Carson City, NVBuilt 1991 · S/N 760380N61DNDn2 Aviation LLC · Fernandina Beach, FLBuilt 1992 · S/N BB-1438N61KATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1989 · S/N FA-200N620NRak Tbvr LLC · Middletown, DEBuilt 1957 · S/N 1026N620WALaboratory Corporation Of America Holdings · Burlington, NCBuilt 2005 · S/N 620N6215MGrant County Mosquito Control District #1 · Moses Lake, WABuilt 2016 · S/N T65HG-029DCN621GZHfjw Properties Leasing LLC · Santa Rosa Beach, FLBuilt 1998 · S/N FL-197N621NHorizon Aviation LLC · Kalispell, MTBuilt 2004 · S/N 4697177N622AWSale Reported · Prattville, ALSale reportedBuilt 2022 · S/N 602-1343N622FCRegistered aircraftN-number assigned, not yet registeredS/N 35048N622KABank Of Utah Trustee · Salt Lake City, UTBuilt 2022 · S/N 602-1335N622KMK & M Equipment Co LLC · Chatsworth, CABuilt 1981 · S/N BB-491N62370Bell Flying Inc · Newport, ARBuilt 2019 · S/N 802A-0787N623BALmco · Vandenberg Afb, CABuilt 2005 · S/N 623N623BFHiggins Leasing Inc · The Woodlands, TXBuilt 2020 · S/N 802A-0827N623LANeal Aircraft Inc · Slaton, TXBuilt 2000 · S/N 402A-1127N623RBAvag Inc · Richvale, CABuilt 2008 · S/N 602-1166N626FCFlorida Department Of Agriculture And Consumer · Tallahassee, FLBuilt 1995 · S/N 35088N626LMOne Percent Aviation LLC · Lewes, DES/N 208B-0694N626NDay William B · Conroe, TXBuilt 1980 · S/N P-545N626TSChorman Spraying LLC · Milton, DEBuilt 2013 · S/N 602-1221N62764Bell Flying Inc · Newport, ARBuilt 2020 · S/N 802A-0859N627EHHound Dog Enterprises LLC · Terre Haute, INBuilt 1991 · S/N T41-158N627LANew Frontier Aviation LLC · Fort Benton, MTBuilt 2005 · S/N 802A-0213N627PCAir First LLC · Kalispell, MTBuilt 1984 · S/N 425501010N628FAAkbj LLC · Lewes, DES/N 802A-0641N628MCAir Methods LLC · Greenwood Village, COBuilt 2003 · S/N 516N629AAAllen Aviation Inc · Aynor, SCBuilt 2023 · S/N T660-182DCN629JPLj Leasing LLC · Cardington, OHBuilt 2002 · S/N 802A-0129N62HQGreen And White Air LLC · Kalamazoo, MIBuilt 1997 · S/N FL-156N62LMBroadway Air LLC · Huntsville, ALS/N 67N62LTLima Tango LLC · Mariposa, CABuilt 2001 · S/N 4697027N62SALta Group Holdings LLC · Amarillo, TXBuilt 1997 · S/N LJ-1472N630LLCroom Aviation LLC · Port Saint Joe, FLBuilt 1994 · S/N T45-006DCN631BLBancfirst · Oklahoma City, OKBuilt 2005 · S/N 631N634BTurbo Air Charter LLC · Boise, IDBuilt 1974 · S/N BC-19N63593Rbr Development LLC · West Plains, MOBuilt 1979 · S/N BB552N635BDodson International Parts Inc · Rantoul, KSBuilt 1977 · S/N BC-49N6366SUS Special Operations Command · Macdill Afb Tampa, FLBuilt 2009 · S/N FL-666
Back to AD 2016-05-13