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.

N191SPJke Helm LLC · Spreckels, CABuilt 1999 · S/N 284N194CSNortheast Montana Stat Air Ambulance Cooperative · Glasgow, MTBuilt 2003 · S/N 533N199CMPassmore Aviation LLC · Claremore, OKBuilt 1999 · S/N 262N1TCMarcare Aviation LLC · Gardnerville, NVBuilt 1995 · S/N 130N201LFFreedom 2026 LLC · Minneapolis, MNBuilt 1996 · S/N 147N207STTwo Bells Aviation LLC · Rockville, MDBuilt 1994 · S/N 107N208CGAspen Homes And Development LLC · Coeur D Alene, IDBuilt 1995 · S/N 132N209PBValiair Limited Co Trustee · Casper, WYBuilt 2005 · S/N 609N212PBGuardian Flight LLC · Lewisville, TXS/N 212N212PKOc Aviation LLC · Victoria, TXBuilt 2005 · S/N 668N214CSHinterland Holdings LLC · Anchorage, AKBuilt 2006 · S/N 766N216KCBlack Kettle Inn LLC · Cabool, MOBuilt 1998 · S/N 216N217EBRapids Camp Lodge Inc · King Salmon, AKBuilt 1996 · S/N 154N219PCRyan Air Inc · Anchorage, AKBuilt 1998 · S/N 219N21AUBoeing Co · Renton, WABuilt 2005 · S/N 606N220JPDragonglass LLC · Denver, COBuilt 2006 · S/N 787N221PCRegistered aircraftS/N 221N2222CDodson International Parts Inc · Rantoul, KSBuilt 2004 · S/N 542N222CMBriar Lakes Productions Inc · Palestine, TXBuilt 1995 · S/N 111N224TWBedford Partners LLC · Oxford, CTBuilt 1997 · S/N 196N226AALegacy Air 03 LLC · Grand Forks, NDBuilt 2003 · S/N 471N227MFMeragals LLC · Evergreen, COBuilt 2003 · S/N 502N227NSDolce Vita Assets LLC · Saint Petersburg, FLBuilt 2006 · S/N 715N228JDValiair Limited Company Trustee · Casper, WYBuilt 1998 · S/N 220N22LPAir Pilatus 22lp LLC · Spanish Fork, UTBuilt 2001 · S/N 402N230UHU-Haul Co Of Oregon · Phoenix, AZBuilt 1998 · S/N 230N231BWN231bw LLC · Hayden, IDBuilt 2004 · S/N 600N234RGCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2003 · S/N 520N236APWestview Payroll Services Inc · Northbrook, ILBuilt 2007 · S/N 804N238VMGuardian Flight LLC · Lewisville, TXBuilt 1998 · S/N 238N241HClassic Medical Inc · Woods Cross, UTBuilt 1998 · S/N 210N242JHDelta Properties Llp · Nogales, AZS/N 232N242MA242ma LLC · Chicago, ILBuilt 2000 · S/N 306N247LCRegistered aircraftBuilt 1999 · S/N 247N247MSPilatus Aircraft USA Ltd · Broomfield, COBuilt 2004 · S/N 558N251JJTvpx Ars Inc Trustee · North Salt Lake, UTS/N 701N253PCIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 1999 · S/N 253N25WAir Watkins LLC · Alpharetta, GABuilt 2002 · S/N 476N260HSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1999 · S/N 260N263RSNorthern Sky Leasing LLC · Middletown, DEBuilt 1995 · S/N 112N264WFWilliams Tim DBA · Knoxville, TNBuilt 1999 · S/N 264N267WFNeljo LLC · Charlottesville, VABuilt 1999 · S/N 267N269CTAero27 Tn LLC · Cookeville, TNS/N 547N269LGCoffin Simon P · RemseckBuilt 2005 · S/N 633N26KHConcord Jet Service Inc · Concord, CAS/N 592N271SMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 622N2727KRegistered aircraftBuilt 2002 · S/N 480N273SMGuardian Flight LLC · South Jordan, UTBuilt 2002 · S/N 475N277PCShc 2021 LLC · Grand Forks, NDBuilt 1999 · S/N 277N278WCN278wc LLC · Greer, SCBuilt 1999 · S/N 278
Back to AD 2008-07-11 R1