OpenAirDocs.org
AD 2008-06-28 R1

Registered aircraft · 16,280

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-28-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-06-28-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.

N8165HNext Centennial Holdings LLC · Alexandria, VABuilt 2003 · S/N 0747N8165NDettore Thomas J · Shavertown, PABuilt 1980 · S/N 32R-8013066N8165RLord David A DBA · Mackay, IDFirst renewal noticeBuilt 1980 · S/N 32R-8029063N81669Esteves Anthony · Hillsborough, NJBuilt 1980 · S/N 28-8016215N8166BBouchard Dustin · Springfield, MOS/N 28-8216129N81673Kcn Aero Club · Overland Park, KSBuilt 1980 · S/N 28-8090258N8167DBurch Robert S · Tyler, TXBuilt 1980 · S/N 32R-8029049N8167FEximious Flying Club Inc · Ferndale, MIBuilt 1983 · S/N 28-8390073N8168QRucks Aviation LLC · Okeechobee, FLBuilt 2004 · S/N 0805N8168VLandau Stephen C · Whitehouse Station, NJBuilt 2003 · S/N 0790N8168WGraham Robert Pierce · Newark, OHS/N 0789N816983000 Summer Street LLC · Brookfield, CTBuilt 1980 · S/N 32R-8013069N816ATSeminole Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 4496535N816BCAv8me LLC · Spicewood, TXBuilt 2004 · S/N 4697195N816BVArtisan Capital Ventures LLC · Romeo, MIBuilt 2005 · S/N 1594N816CACirrus Access LLC · Buckner, KYBuilt 2020 · S/N 2567N816CDDodson International Parts Inc · Rantoul, KSS/N 0150N816CTKejair LLC · San Francisco, CABuilt 2018 · S/N 2415N816GGGoodwin Bryan · Fort Smith, ARBuilt 2019 · S/N 4697658N816JGPie Haven LLC · Fort Lauderdale, FLBuilt 2016 · S/N 4636696N816JTRed Angel Wings LLC · Colorado Springs, COS/N 41058N816LDJazz Aviation LLC · Largo, FLBuilt 2012 · S/N 3843N816LNAircraft Partner Holdings Inc Trustee · BerlinBuilt 2021 · S/N 5030N816LPCirrus Design Corp · Duluth, MNS/N 11671N816LTSix Lima Tango LLC · Zionsville, INBuilt 2003 · S/N 0511N816MMFlight Dynamics LLC · Clifton, VABuilt 2022 · S/N 8797N816PKSix Papa Kilo Aviation LLC · Savannah, GAS/N 28-8090334N816PPAia Alpha LLC · Henderson, NVBuilt 2024 · S/N 10266N816RJArkansasflyingdoc LLC · Benton, ARBuilt 2001 · S/N 0112N816SCFirst Hand Transportation LLC · Lake Orion, MIBuilt 2006 · S/N 1878N816SDCcr Inc · Tulsa, OKBuilt 2007 · S/N 2323N816SFTbf Aviation LLC · Park City, UTBuilt 2008 · S/N 411115N816SRInalytix LLC · New York, NYBuilt 2019 · S/N 10135N816TPDefense Research Institute Inc · Fayetteville, NCBuilt 2012 · S/N 4636529N8170AAlpha Aviation LLC · Springfield, MOBuilt 2003 · S/N 0745N8170EInternational Air Services Inc Trustee · Carson City, NVBuilt 2004 · S/N 0809N8170FAlfonso Peter J · Jamestown, RIBuilt 1980 · S/N 32R-8013071N8170GBucher Max · Fort Mohave, AZBuilt 1982 · S/N 34-8233116N8170SSkywagons.Com LLC · Placerville, CAS/N 32R-8029067N8170YRaven Aeronautics Ltd · Monument, COBuilt 1980 · S/N 32R-8029069N81713Brown Matthew · Spokane, WABuilt 1980 · S/N 28-8016290N81715Registration Pending · Hanford, CARegistration pendingS/N 28-8016291N8171GEdge Air LLC · Wilmington, DEBuilt 2003 · S/N 0751N8171PTravelplus LLC · Knoxville, TNBuilt 2004 · S/N 0797N8171YFaith Works Aviation LLC · Glenmoore, PABuilt 1980 · S/N 28-8016284N8172NBeasley Michael Jeffrey · Dothan, ALS/N 28-8090261N8172PWison Keene · Abbeville, GABuilt 1981 · S/N 32R-8129028N8172QFrost Aviation Services Inc · Las Cruces, NMBuilt 1980 · S/N 28-8090263N8172ZAverka Steven D · Sutton, MABuilt 1980 · S/N 28-8090264N81737Our Props LLC · Lewes, DEBuilt 2004 · S/N 1397
Back to AD 2008-06-28 R1