Skip to content

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

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

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.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N82122Takeoff2entertainment LLC · Lake Havasu City, AZBuilt 1982 · S/N 28-8290140 N8212DN8212d LLC · Elkins Park, PABuilt 2025 · S/N 10717 N8214EWayland Steven L · Southlake, TXBuilt 1980 · S/N 32R-8029092 N8214HRuetsch Derek R · Goodyear, AZBuilt 1980 · S/N 32R-8029093 N8214PVertical Air LLC · Farmington, NMS/N 32R-8029095 N8214QB & B Flying LLC · Green River, WYBuilt 1980 · S/N 32R-8029096 N8214YRegistration Pending · Harrisburg, SDRegistration pendingBuilt 1980 · S/N 28-8090362 N82162Conner Larry W · Los Lunas, NMBuilt 1982 · S/N 32R-8313015 N8216SNulton Enterprises LLC · Johnstown, PABuilt 1980 · S/N 28-8016328 N82173Gagnier Hugh K · Hidden Hills, CABuilt 1982 · S/N 32R-8229055 N8217QParis Air Inc · Vero Beach, FLBuilt 1980 · S/N 28-8016334 N8217SValles Robert Jr · Spicewood, TXBuilt 1980 · S/N 28-8016335 N8217ZPerry Richard F · Lexington, MABuilt 1982 · S/N 32R-8213051 N8218AFirst Flight Inc · Watertown, CTBuilt 1982 · S/N 32R-8229064 N8218KN8218k LLC · Chico, CABuilt 1982 · S/N 32R-8229063 N8218SThoroughbred Aviation Ltd · State College, PABuilt 1982 · S/N 34-8233165 N8218ZWingsleasing LLC · Wichita, KSBuilt 1980 · S/N 28-8090320 N821ADPlanecents LLC · Sheridan, WYBuilt 2017 · S/N 4697622 N821ATSeminole Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 4496539 N821BERas Aviation LLC · Elyria, OHBuilt 1978 · S/N 28-7816398 N821CVSea Duck LLC · Miami, FLFirst renewal noticeBuilt 2016 · S/N 4374 N821FJ8th Dimension Enterprises LLC · Aurora, ORBuilt 2021 · S/N 28020032 N821GCascade Virga LLC · Wilmington, DEBuilt 2005 · S/N 1471 N821GTChatelain Ray · Lago Vista, TXBuilt 2013 · S/N 3932 N821JRegistration Pending · West Branch, MIRegistration pendingBuilt 2003 · S/N 4697172 N821LGKaufman Matthew Todd · Bonny Doon, CABuilt 2007 · S/N 40.816 N821MSAci Enterprises LLC · Costa Mesa, CABuilt 2014 · S/N 4052 N821PGreen Bandit Air LLC · Vinita, OKBuilt 2018 · S/N 4723 N821PASkywest Leasing Inc · St George, UTBuilt 2019 · S/N 2881248 N821RTWest States Leasing Inc · Medford, ORBuilt 2022 · S/N 8865 N821SRN821sr LLC · Rio Rancho, NMBuilt 2007 · S/N 2614 N821TColquhoun Steven · North Augusta, SCBuilt 2012 · S/N 40.1154 N821WMMaricorp Aviation LLC · Shell Knob, MOBuilt 2005 · S/N 1480 N8220QWallentine Ranch LLC · Dover, DEBuilt 1980 · S/N 32R-8029097 N8220WSb Farms LLC · Bowling Green, OHBuilt 1980 · S/N 32R-8029099 N82221Hahn Dave · Brooklyn Park, MNBuilt 1980 · S/N 28-8090323 N82226Plane & Pilot News · Ravenna, OHBuilt 1980 · S/N 28-8090324 N8222DPaphos Airways LLC · Farmingdale, NYBuilt 1980 · S/N 28-8016337 N8222FJefferson City Aviation Inc · Jefferson City, MOBuilt 1980 · S/N 28-8016338 N8222HBartek Matthew S · Wylie, TXBuilt 1980 · S/N 28-8016339 N8222JShvetsov Vitaly S · La Canada Flintrid, CABuilt 1980 · S/N 28-8016340 N8222YMorale Line Aviation LLC · Albuquerque, NMBuilt 1980 · S/N 28-8090322 N8223TTrident Aircraft Leasing LLC · Easton, MDBuilt 1982 · S/N 28-8216170 N82241Naranjo Navarro Jose N · Las Vegas, NVS/N 28-8390018 N8224KPelayes Tristan · Temecula, CABuilt 1982 · S/N 28-8216171 N82255Quinn John J III · Merritt Island, FLBuilt 1982 · S/N 32R-8213053 N8225RNorris Craig A · San Carlos, CABuilt 1980 · S/N 32R-8029100 N8225UNagy John F · Whittier, CABuilt 1982 · S/N 28-8290143 N8225VRunge Thomas A · Sterling, VABuilt 1982 · S/N 28-8290144 N8225XWarren Dennis J · Denver City, TXBuilt 1982 · S/N 28-8290145

Back to AD 2008-06-28 R1