AD 2016-01-01

Registered aircraft · 412

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

N46PLAvcorp Leasing Inc Trustee · Wilmington, DEBuilt 2001 · S/N 4697054N4757SBombay Glass Corp · Depoe Bay, ORS/N 4697006N477HCParish Air Inc · San Diego, CABuilt 2003 · S/N 4697171N47HPBuddy Air LLC · West Bend, WIS/N 4697201N481CBTern Royal LLC · Camp Hill, PABuilt 2013 · S/N 4697517N4839RGnome Holding Company LLC · Columbus, GABuilt 2007 · S/N 4697293N487LBarkair LLC · Alpine, WYBuilt 2011 · S/N 4697468N488WAEcc Corp · Cumberland, RIBuilt 2012 · S/N 4697488N492FZFishkind Aircraft Holding LLC · Orlando, FLBuilt 2019 · S/N 4697663N49BTFlight Levels LLC · Ridgeland, MSBuilt 2003 · S/N 4697161N4NYLesair LLC · Framingham, MABuilt 2014 · S/N 4697572N500BRSevenlimamike LLC · Cleveland, TNBuilt 2007 · S/N 4697290N500HAWandering Quarks LLC · Lincolnville, MEBuilt 2005 · S/N 4697222N500JM500jm Aviation LLC · Westfield, INBuilt 2001 · S/N 4697118N500JRReel Aviators LLC · Scottsdale, AZBuilt 2015 · S/N 4697585N500PEO2flyhi LLC · Brooksville, FLBuilt 2015 · S/N 4697600N500XRRjt Equipment LLC · Lubbock, TXBuilt 2016 · S/N 4697609N509PM777tz LLC · Lubbock, TXBuilt 2012 · S/N 4697509N50GKRedwood Air LLC · Roanoke, TXBuilt 2008 · S/N 4697376N51019Lohmann Jack R · Frisco, COBuilt 2000 · S/N 4697008N512MMBuckeye Creek Ventures LLC · Belle Plaine, IABuilt 2006 · S/N 4697271N515BRDmfs Leasing LLC · Des Moines, IABuilt 2025 · S/N 4697727N515CTMalibu LLC · Portland, ORS/N 46-97048N520HPHutton Mark · Denison, TXBuilt 2000 · S/N 46-97012N5215UTwin Peaks Aviation LLC · Missoula, MTS/N 4697068N524PMSky Train Air LLC · Templeton, CABuilt 2000 · S/N 46-97024N526AGValiair Lc Trustee · Casper, WYBuilt 2014 · S/N 4697562N526FGTuggle David Eric · Albuquerque, NMBuilt 2013 · S/N 4697526N529PMCarolina Express LLC · Fairmont, MNS/N 46-97029N530HPCreek Canyon Aviation LLC · Phoenix, AZBuilt 2001 · S/N 4697101N5319KEyedollar LLC · Denton, TXS/N 4697076N5320NSaunders Aviation LLC · Lewes, DEBuilt 2003 · S/N 4697153N5322DBlack Phoenix Photography LLC · Morgan Hill, CABuilt 2001 · S/N 4697074N5322MFlight Club LLC · Erie, PABuilt 2000 · S/N 4697021N53235Aerospace Trust Management LLC Trustee · Wilmington, DES/N 4697083N5325PJpr Investments LLC #51 · Fargo, NDS/N 4697085N5329QMitzel Eddy Jacob · Mandan, NDS/N 4697097N532STNovaair LLC · Lake Sherwood, CABuilt 2013 · S/N 4697532N53369Poor Boy Aero LLC · Seminole, TXBuilt 2001 · S/N 4697088N5337NInternational Air Services Inc Trustee · Carson City, NVS/N 4697102N5338MAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 4697103N5339G5339g LLC · Vero Beach, FLFirst renewal noticeBuilt 2001 · S/N 4697095N5341CMobilesphere LLC · Cambridge, MABuilt 2002 · S/N 4697142N5347VDe Boissard Karen · New York, NYS/N 4697126N53516Flight Group LLC · Bend, ORBuilt 2002 · S/N 4697132N5353VMidwest Ventures LLC · Wichita, KSBuilt 2002 · S/N 4697141N5355SJohn Galt Industries LLC · Charlevoix, MIBuilt 2002 · S/N 4697136N5358JAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 2002 · S/N 4697140N535JRGreenville Pickens Roundtrac LLC · Easley, SCBuilt 2006 · S/N 4697253N5361AChavers Construction Inc · Cantonment, FLBuilt 2002 · S/N 4697144
Back to AD 2016-01-01