OpenAirDocs.org
AD 2008-06-15

Registered aircraft · 541

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

N102LBCatskill Mountain Balloon Inc · Oneonta, NYBuilt 2015 · S/N 5575N103LBBalloon Promotions Ltd · Louisville, KYBuilt 2000 · S/N 5157N104LBDougherty Don A · Colorado Springs, COBuilt 1998 · S/N 5079N105GHMagniflight LLC · Arlington, TXBuilt 2018 · S/N 5675N105HMGliatti Michael E · Oregonia, OHBuilt 2020 · S/N 5710N105PFFan-C Inc · Loveland, COBuilt 2004 · S/N 5282N107ECWassom Robert · Prosser, WABuilt 2007 · S/N 5351N107LBGaessler Bert C · Rockford, ILBuilt 1998 · S/N 5086N108AJChristensen Balloons LLC · Hot Springs, SDS/N 5512N108KFForrest Services LLC · Dayton, NVBuilt 2017 · S/N 5645N10WMCalistoga Ballooning Adventures Inc · Napa, CABuilt 2012 · S/N 5479N110HDLang Neil D · West Des Moines, IAS/N 5241N110LBVesely Scott · Frisco, TXBuilt 2003 · S/N 5224N110TECoop Balloons LLC · Swisher, IAS/N 5698N111RGAeronautical Solutions LLC · Taos, NMBuilt 1995 · S/N 197N112RDObrien Robert P · Waupaca, WIBuilt 1998 · S/N 535N114LBSeize The Breeze LLC · Southampton, NJBuilt 2009 · S/N 5446N115LBBoylan Michael E · Washington, ILBuilt 2012 · S/N 5527N116LBWinkel John H · Marion, IAS/N 5162N118LBBrodbeck Amanda Pearl · Dacono, COBuilt 2001 · S/N 5179N120LBPlano Balloon Festival Inc · Plano, TXBuilt 2004 · S/N 5234N120SMXclusive Balloons LLC · Taylorsville, KYBuilt 2010 · S/N 5472N123EVWeiscopf Charles W · Roseville, CABuilt 2010 · S/N 5471N124BBMay First Inc · Fishers, INBuilt 2009 · S/N 5429N126LBWelch Tracy L · Lincoln, ILBuilt 2003 · S/N 5245N126LEIsley Todd D · Carlisle, IABuilt 2012 · S/N 5499N126RRRainbow Ryders Inc · Albuquerque, NMBuilt 2023 · S/N 5794N129LBMckenzie Dawn R · Birmingham, MIBuilt 1999 · S/N 5102N129WBFour Corners Balloon Rides LLC · Rio Rancho, NMBuilt 1993 · S/N 2426N130BKShoemaker Mark K · Lebanon, MOBuilt 2009 · S/N 5451N130LBGoll Scooter · Longview, TXS/N 5084N134LBSchmoldt Ventures LLC · Bayside, WIBuilt 1998 · S/N 5063N140BAAreostats International Ltd · Temecula, CAS/N 1186N140CCBuzzards Glory Balloon Co LLC · Cedar Rapids, IABuilt 2011 · S/N 5485N1410CElevated Ballooning · Driggs, IDBuilt 2006 · S/N 5345N143DCBrooks Carolyn M · Milton Freewater, ORBuilt 2002 · S/N 5199N145LBBiernacki Buzz · Albuquerque, NMBuilt 2005 · S/N 5314N146LBWilliams Robert L · Ellenton, FLBuilt 2004 · S/N 5253N148LBHintz Kurtis D · Appleton, WIS/N 5350N14YMSkycab Balloon Promotions LLC · Louisville, KYBuilt 2006 · S/N 5342N1503TLohmeyer Wayne D · Katy, TXBuilt 2006 · S/N 5335N15071Wooge Glen S · Swisher, IAS/N 5423N150LBShipman Shane L · Rio Rancho, NMS/N 5315N1513WFahrendorf Michael J · Pilot Grove, MOBuilt 2005 · S/N 5323N1514KBig Sky Balloon Co · Redmond, ORS/N 5340N1517HWooge Glen S · Swisher, IABuilt 2007 · S/N 5371N1519HRed Baron Balloon Corps LLC · Lebanon, OHBuilt 2006 · S/N 5338N1520HTjv Balloons Inc · Bloomington, INBuilt 2007 · S/N 5360N1521YTimko Steven O · Califon, NJBuilt 2006 · S/N 5321N1524ARe/Max Marketing Fund LLC · Denver, COBuilt 2007 · S/N 5375
Back to AD 2008-06-15