OpenAirDocs.org
AD 2016-01-19

Registered aircraft · 66

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-19')
    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-19')
  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.

N102CGSale Reported · Surprise, AZSale reported, pending cancellationBuilt 1998 · S/N LNO85N103CGCity Of Burbank · Burbank, CABuilt 2006 · S/N LN102N18GHCity And County Of Honolulu · Honolulu, HIS/N LN014N209ECYavapai County · Prescott, AZBuilt 2007 · S/N RN074N215MBunn Mary E · Williamstown, WVBuilt 1997 · S/N LN083N261VSVertol Systems Company Inc · Destin, FLS/N RN061N266VSVertol Systems Company Inc · Destin, FLBuilt 2002 · S/N RN066N300FXFxc Nation Leasing LLC · Palm Springs, FLBuilt 2000 · S/N RN056N301HFCity And County Of Honolulu · Honolulu, HIS/N LN075N302HFCity And County Of Honolulu · Honolulu, HIBuilt 1992 · S/N LN023N303HFHonolulu Fire Department · Honolulu, HIBuilt 1994 · S/N LN064N33CSunshine 123 LLC · Wilmington, DEBuilt 2018 · S/N LN113N3500XHelicopter Flight Services LLC · Groton, SDBuilt 2000 · S/N RN047N375SDBrown Helicopter Inc · Pensacola, FLS/N RN010N39GACrosswind Leasing LLC · Prescott, AZBuilt 1998 · S/N RN039N416MMountain Ridge Helicopters LLC · Murray, UTBuilt 1998 · S/N RN043N420GCRegistered aircraftBuilt 2005 · S/N RN053N507CCRotorworks LLC · Hiram, GABuilt 1997 · S/N RN007N510PJMid Pacific Aero Services LLC · Honolulu, HIBuilt 1993 · S/N LN054N511VAAb Monterrey Aircraft LLC · Newark, DES/N RN023N512PJMid Pacific Aero Services LLC · Honolulu, HIBuilt 1992 · S/N LN020N513PJMid Pacific Aero Services LLC · Honolulu, HIBuilt 1993 · S/N LN048N515THRick'S Custom Fencing And Decking Inc · Hillsboro, ORBuilt 2002 · S/N LN099N520ANHeliservices LLC · Wilmington, DEBuilt 1992 · S/N LN-034N520APLn095 1vc Trustee · Wilmington, DEBuilt 2001 · S/N LN095N520EALn062 Inc Trustee · Wilmington, DEBuilt 1994 · S/N LN062N520HSHfn Investments LLC · Birmingham, ALBuilt 1992 · S/N LN012N520KYAltadena LLC · Birmingham, ALBuilt 1992 · S/N LN041N520MDChatham County Mosquito Control · Savannah, GABuilt 1992 · S/N LN039N520MGHagedorn Aviation · Columbus, OHBuilt 1992 · S/N LN004N520MHSilver Cloud One LLC · Reno, NVBuilt 1993 · S/N LN057N520NQuantumtrace Inc · Incline Village, NVBuilt 1992 · S/N LN031N520NMWillard Development Inc · Port Saint Lucie, FLBuilt 1992 · S/N LN021N520NTAurora Meridian LLC · Portland, ORS/N LN066N520PDCity Of Glendale Police Department · Glendale, CABuilt 2014 · S/N LN111N520VCVolusia County Mosquito Control · New Smyrna Beach, FLBuilt 2015 · S/N LN112N523CPHowe Aviation LLC · Surprise, AZS/N LN003N523HBCrg2 LLC · Lees Summit, MOBuilt 2007 · S/N LN105N527FBChatham County Mosquito Control · Savannah, GABuilt 1992 · S/N LN007N555MSAvioelectronica Inc DBA · Coral Springs, FLS/N RN079N600ESIron Horse Aviation LLC · Newton, IAS/N RN030N600FTLancair Of Texas DBA · Fort Worth, TXBuilt 2008 · S/N RN077N600MWSale Reported · West SussexSale reportedBuilt 2001 · S/N RN064N600NRSharcott Inc Trustee · Wilmington, DEBuilt 2008 · S/N RN073N609RPRonald A Peterson Inc DBA · Orlando, FLBuilt 1997 · S/N RN009N60BKBrim Equipment Leasing LLC · Ashland, ORBuilt 1998 · S/N RN028N630AGLafayette Aircraft Leasing LLC · Fort Lauderdale, FLBuilt 1997 · S/N RN015N641LBGr (Uk) Inc Trustee · Wilmington, DEBuilt 1998 · S/N RN041N672TSS2md LLC · Lillian, ALS/N LN049N678SKLga 1992 LLC · Aubrey, TXBuilt 2010 · S/N RN078
Back to AD 2016-01-19