OpenAirDocs.org
AD 2008-07-11 R1

Registered aircraft · 545

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-07-11-R1')
    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-07-11-R1')
  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.

N355AF355af LLC · Naples, FLBuilt 2000 · S/N 345N359CVWen LLC · Spokane, WABuilt 2000 · S/N 382N35WAMontana Jet LLC · Monterey, CAS/N 770N368PCIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 2001 · S/N 368N373KMRebel One LLC · Danville, KYBuilt 2000 · S/N 373N376KCKaiser Midwest Inc · Marble Hill, MOS/N 376N377LGuardian Flight LLC · Lewisville, TXBuilt 2000 · S/N 346N378HHGuardian Flight LLC · Lewisville, TXBuilt 2001 · S/N 378N380TMDonald Farms Inc · West Monroe, LABuilt 2000 · S/N 380N381SLMoney Multiplier Meridian LLC · Port Orange, FLBuilt 2001 · S/N 381N387WState Of Wisconsin · Madison, WIBuilt 2001 · S/N 387N388PCOair LLC · Jacksonville, FLBuilt 2001 · S/N 388N389WState Of Wisconsin · Madison, WIBuilt 2001 · S/N 389N392WCGuardian Flight LLC · Lewisville, TXS/N 392N395PCObrien Adventures LLC · Prescott, AZBuilt 2001 · S/N 395N395WState Of Wisconsin · Madison, WIBuilt 2001 · S/N 394N398JMds Leasing LLC · Middletown, DEBuilt 2001 · S/N 398N399AMUniversity Of Utah · Salt Lake City, UTBuilt 1999 · S/N 249N399SAQuest Diagnostics Clinical Laboratories Inc · Reading, PABuilt 2001 · S/N 407N400ACFly Pilatus LLC · Naples, FLBuilt 2002 · S/N 472N400BWRaw Inc · Raleigh, NCBuilt 1998 · S/N 224N401PDPilatus Aviation LLC · Austin, TXBuilt 2001 · S/N 401N404BFMcdunn Air LLC · Oklahoma City, OKBuilt 2001 · S/N 386N405HRKg Aviation LLC · Huntington, WVS/N 199N405MNBank Of Utah Trustee · Salt Lake City, UTBuilt 2001 · S/N 405N408FZFlying Zebra Aircraft Holdings LLC · West Harrison, NYBuilt 2005 · S/N 683N409FZFlying Zebra 409 Inc · West Harrison, NYBuilt 2004 · S/N 550N409LTHarmsantos Enterprises LLC · Park City, UTS/N 1091N410WRRyan Air Inc · Anchorage, AKBuilt 2007 · S/N 818N411MVCowtown Investments LLC · Portola Valley, CABuilt 2000 · S/N 344N411PCPremier Aircraft Sales Inc · Fort Lauderdale, FLBuilt 1995 · S/N 108N412CUGuardian Flight LLC · Lewisville, TXBuilt 2002 · S/N 469N412MDQuest Diagnostics Clinical Laboratories Inc · Reading, PABuilt 2001 · S/N 412N416TWBedford Partners LLC · Oxford, CTBuilt 2001 · S/N 416N417ARGreenway Air LLC · Orlando, FLS/N 611N417KCFeatherstone Two LLC · Tampa, FLBuilt 2001 · S/N 417N418DRAustin Aviation LLC · Phoenix, AZBuilt 1997 · S/N 192N418FMRegistered aircraftBuilt 1999 · S/N 246N420DWTmm LLC · Elkhorn, NEBuilt 2001 · S/N 404N422MUChinook Inc · Colorado Springs, COBuilt 2000 · S/N 336N423MGMike Gulf LLC · Fort Lauderdale, FLBuilt 1996 · S/N 140N423WAAlleghany Ridge LLC · Middletown, DEBuilt 2001 · S/N 423N425EVLegacy Air 02 LLC · Grand Forks, NDBuilt 2005 · S/N 674N427WA427wa LLC · Nashville, TNBuilt 2001 · S/N 427N42DPAircraft Finance Partners Vii LLC · Dallas, TXBuilt 1999 · S/N 252N431WCPelican Pacific Air LLC · Pleasanton, CABuilt 2001 · S/N 431N432MHJth Air LLC · South Daytona, FLBuilt 2001 · S/N 432N434JAJackson Air Charter LLC · Charlottesville, VABuilt 2007 · S/N 819N439WCHarlyn Holdings LLC · San Antonio, TXBuilt 2002 · S/N 439N43CFAb Monterrey Aircraft LLC Trustee · Newark, DEBuilt 2001 · S/N 433
Back to AD 2008-07-11 R1