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.

N517SCSpartan Education LLC · Tulsa, OKBuilt 2019 · S/N 2881264N517SWStarship Aviation LLC · Northville, MIBuilt 2003 · S/N 0666N517XEezrx LLC · Athens, OHBuilt 2008 · S/N 411117N518AFAmerican Air Academy Inc · Merritt Island, FLBuilt 2021 · S/N 28020047N518AMRise Above Entertainment LLC · Wyandotte, MIBuilt 2008 · S/N 4692089N518AVWestwind School Of Aeronautics Phoenix LLC DBA · Goodyear, AZBuilt 2023 · S/N 9568N518AWN All Cirrusness LLC · Lake Charles, LABuilt 2014 · S/N 4129N518BADalton Wholesale Floors Of Gordon County Ga Inc · Adairsville, GABuilt 2015 · S/N 4183N518BBJ S Aviation Corp · Farmingdale, NYBuilt 2006 · S/N 2842258N518BPDr James Loging Md LLC · Prosperity, SCBuilt 2007 · S/N 2683N518C30air LLC · Camden, DEBuilt 2008 · S/N 4636449N518CDCornerstone Auto Parts LLC · Pratt, KSBuilt 2004 · S/N 1229N518CPDdr Enterprises LLC · Kodak, TNBuilt 2008 · S/N 3324N518FDCirrus Design Corp · Duluth, MNBuilt 2025 · S/N 10518N518GERichtair LLC · Alpharetta, GABuilt 2023 · S/N 4636818N518JSDubbs Chad T · Naples, FLBuilt 2003 · S/N 3246212N518LSeehimfly LLC · Spring, TXBuilt 2003 · S/N 42028N518LMResnik Robert · Scottsdale, AZBuilt 2006 · S/N 2183N518MACapital Affairs West LLC · Helena, MTBuilt 2005 · S/N 40.565N518MDGreens Aviation LLC · Lebanon, OHBuilt 2004 · S/N 1183N518PTTcp Air LLC · Enid, OKBuilt 2021 · S/N 2704N518VAN518va LLC · Latham, NYBuilt 2026 · S/N 11169N518VVN518vv LLC · Latham, NYBuilt 2026 · S/N 11174N5194CDk Advanced Management Solutions Inc · Rockledge, FLBuilt 2008 · S/N 411079N5194YNorthgate Aviation LLC · Colorado Springs, COBuilt 2008 · S/N 411007N5195LAdams Charlie H Jr · Blairsville, GABuilt 2008 · S/N 411015N5197FKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 1976 · S/N 28-7790086N519AFVee Two Inc · Merritt Island, FLBuilt 2021 · S/N 28020048N519BRSilver Train Management LLC · Raleigh, NCBuilt 2013 · S/N 3948N519CBMidwest Liquidation LLC · Grand Meadow, MNBuilt 2011 · S/N 3819N519DBN519db LLC · Dover, DEBuilt 1978 · S/N BB-436N519DENiner Delta Echo Inc · Milton, DEBuilt 2006 · S/N 1964N519DHDavis Steven Jeffry Trustee · Poway, CABuilt 2002 · S/N 0233N519DMSingh Aviation LLC · San Antonio, TXBuilt 2012 · S/N 4636528N519DSVkda LLC · West Linn, ORBuilt 2006 · S/N 40.619N519JLakeland Tower Leasing Co · Traverse City, MIBuilt 1968 · S/N 28R-30376N519KR519kr LLC · Signal Mountain, TNBuilt 2002 · S/N 1250N519PWBlackmore Roberta L · Durango, COBuilt 2006 · S/N 41610N519SRSale Reported · Seneca, SCSale reportedBuilt 2006 · S/N 2072N519TMNysflight Aviation LLC · Tucson, AZBuilt 2007 · S/N 40.818N519WRTsmhta LLC · Indianapolis, INBuilt 2000 · S/N 4636259N519WVRegistered aircraftBuilt 2008 · S/N 2998N51AHInternational Air Services Inc Trustee · Carson City, NVBuilt 1984 · S/N 32R-8413017N51BKBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 4636566N51CWAviation Enterprises LLC · Bath, MEBuilt 2020 · S/N 4969N51DNDjl Investments LLC · Gilroy, CABuilt 1972 · S/N LW-7N51GKHelgeson Todd R · Port Orange, FLBuilt 2004 · S/N 41042N51KJWoodward Perry James · San Jose, CABuilt 2008 · S/N 411113N51LAKrauss Elliot A · Princeton, NJBuilt 2005 · S/N 1756N51PGFly N' Fish LLC · Jacksonville, FLBuilt 1984 · S/N 32R-8529003
Back to AD 2008-06-28 R1