OpenAirDocs.org
AD 2008-04-15

Registered aircraft · 144

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

N1049FBissonette Harle E · Brookings, ORBuilt 1979 · S/N 182N104TCAskren Richard S · Middletown, OHBuilt 1996 · S/N 3971N105VTApogee Associates LLC · Portage, MIBuilt 2006 · S/N 355N1084HVest Richard D · Jacksonville, FLS/N 101N120KSStepanek Edward B · Cleveland, NCS/N 388N120TCDavis Cory M · Carrollton, TXBuilt 1990 · S/N 1869USAN1222HHosmer Brad · Galesburg, MIBuilt 2023 · S/N 509N126TCEakes Benjamin V · Meridian, MSBuilt 1991 · S/N 1880USAN140PSJohnson Durwood D · Beaumont, TXBuilt 1989 · S/N 1470USN144BAMaez Manuel E · Peralta, NMS/N 1133N145BAPulaski Robert A · Pineville, LABuilt 1987 · S/N 1132N19852Ross Fred · Hollywood, FLS/N 137N1985DGunby Robert W · Stapleton, GABuilt 1985 · S/N 120N2007SBassett William C · Sultan, WAS/N 436N2011WClodfelder Dean M · Marysville, OHBuilt 2011 · S/N 405N2015MJones Robert J · Seale, ALBuilt 2011 · S/N 414N2021VVansicklen Tiffany · Forestdale, MAS/N 398N2023NSky Pirates Ballooning And Gifts LLC · Lake Wales, FLBuilt 2011 · S/N 412N2028CSky Odysseys LLC · Longmont, COBuilt 2006 · S/N 353N2028LHurdt Joseph A · Shelby, NCBuilt 2009 · S/N 392N2030DRistaino Damien · Charlotte, NCS/N 402N2030EEgerton Louise H · Brevard, NCBuilt 2010 · S/N 400N2030JBalloon Stormers Inc · Ashland, MOS/N 408N2032QPurvis George W · Tallahassee, FLBuilt 2015 · S/N 445N2036XTomasetti David C · Raleigh, NCS/N 362N2039AAir Carriage LLC · Sandia Park, NMS/N 407N2044SHerbst John H · Lexington, KYS/N 403N2046DThum Kevin D · Colorado Springs, COS/N 404N2049YAlbers David · Phoenix, AZBuilt 2011 · S/N 406N205AXWillbanks Robert S · Lavonia, GABuilt 1987 · S/N 128N207TCGauthier Martin T · Waterford, MIBuilt 1991 · S/N 2012USAN2083KShute Steven D · Richmond, INBuilt 2004 · S/N 335N2135RGriffith Justin M · Albuquerque, NMBuilt 2009 · S/N 394N2146BHigher Reach LLC · Meridian, IDBuilt 2008 · S/N 379N2162JMaddox Jeffrey A · Toney, ALS/N 343N2164JHendershot James M · Townville, SCBuilt 2008 · S/N 372N2269SMartens Eric A · Indianola, IABuilt 2007 · S/N 361N227TCEagy Gregory L · Boise, IDBuilt 1992 · S/N 2067USAN2385RPalmer Arthur R · Middletown, NYBuilt 2011 · S/N 411N2405EDougherty Donald A · Colorado Springs, COBuilt 2007 · S/N 367N2421AGreen Mark T · Orlando, FLBuilt 2007 · S/N 365N2421HGarner Kenneth W · Decatur, ALBuilt 2008 · S/N 376N24220Quinn Megan M · Fort Edward, NYBuilt 2007 · S/N 369N24225Monahan Todd J · Queensbury, NYS/N 368N2423NBig Sky Balloon Co · Redmond, ORBuilt 2014 · S/N 431N244TCFear Robert C · Rio Rancho, NMBuilt 1992 · S/N 2105USAN246TCGood John R · Prairieville, LAS/N 2094USAN24LLLitton Jenna · Statesville, NCS/N 118N2622DHargrave Zechariah R · Mesa, AZS/N 319N2681LOtero Charlie M · Corrales, NMS/N 386
Back to AD 2008-04-15