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.

N834NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2020 · S/N 2881304 N834RVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1982 · S/N 34-8233111 N834TFAir Fleet Holdings LLC · Missoula, MTBuilt 2024 · S/N 2881707 N8350ZBas Part Sales LLC · Greeley, COBuilt 1981 · S/N 34-8133034 N8351BPanning Eric M · Portland, ORBuilt 1981 · S/N 34-8133035 N8351WQuality Aero LLC · East Aurora, NYBuilt 1981 · S/N 28-8116176 N8352DScarlet Wings LLC · Brunswick, OHBuilt 1981 · S/N 28-8116179 N8352TFlight Inc · Lakewood, COBuilt 1981 · S/N 28-8190187 N8353DKauffman Land & Development LLC · Fort Lupton, COBuilt 1981 · S/N 28-8190189 N83540Red Tail Scholarship Foundation · Tuskegee, ALBuilt 1981 · S/N 28-8190190 N8354CTayab Farooq · Allen, TXBuilt 1976 · S/N 28-7690122 N8355EHigh Noon Leasing LLC · Anchorage, AKBuilt 1981 · S/N 32R-8113052 N8355HLjmf 17 LLC · Hays, KSBuilt 2001 · S/N 3257204 N8355XSkyway Leasing Co Inc · Yakima, WABuilt 1981 · S/N 32R-8129053 N83562Wilson Michael · Missouri City, TXBuilt 1981 · S/N 34-8133042 N8356XRys Sebastian M · Paterson, NJBuilt 1981 · S/N 34-8133041 N8358ZMinella Frank A · Old Forge, PABuilt 1981 · S/N 28-8190192 N8359XW&H Services LLC · Boerne, TXBuilt 1981 · S/N 32R-8113055 N835ATDot Aviation LLC · Wilmington, DEBuilt 2012 · S/N 4496315 N835DSFederal Service Corp · Bay Minette, ALBuilt 2001 · S/N 40035 N835EFLufthansa Aviation Training USA Inc · Goodyear, AZBuilt 2017 · S/N 2380 N835NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2019 · S/N 4496472 N835WBLowell Jonathan B · West Boylston, MABuilt 2023 · S/N 9484 N8360GSophamike Aviation LLC · Hattiesburg, MSBuilt 1981 · S/N 32R-8129057 N8360YOtto Aviation LLC · Gilbertsville, PABuilt 1981 · S/N 28-8190195 N83612Ort Mark P · Pickerington, OHBuilt 1981 · S/N 32R-8113059 N83615Brown Thomas E · Union Grove, ALBuilt 1981 · S/N 32R-8129058 N8362DCoco Aircraft Inc · Merritt Island, FLS/N 34-8133052 N8362YScherr Steven J · Mandan, NDBuilt 1981 · S/N 34-8133057 N8363EEllefson Aircraft LLC · Tyler, MNS/N 28-8116187 N8363HFox John · Asheboro, NCBuilt 1981 · S/N 28-8116188 N8363PLove Richard S · Indianapolis, INBuilt 1981 · S/N 28-8116191 N8363ZGobel Mario · Belleville, WIFirst renewal noticeBuilt 1981 · S/N 28-8190202 N8364GMcintosh Warren K · Cookeville, TNBuilt 1981 · S/N 28-8190203 N8365ZScorse Jeffrey A · Lunenburg, MABuilt 1981 · S/N 28-8116196 N8366NLakes Region Flying Club Inc · Gilford, NHBuilt 1981 · S/N 28-8190205 N8366ZApm Leasing LLC · Casper, WYBuilt 1981 · S/N 28-8190206 N83670Aerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1981 · S/N 28-8190210 N8367SBaer Donald J · Groton, CTBuilt 1981 · S/N 28-8190207 N83694Heatwole Oren E · Dayton, VABuilt 1981 · S/N 32R-8113060 N8369ANorthern Ventures II LLC · Carl Junction, MOS/N 28-8116198 N8369XTemesvary Peter · Katy, TXBuilt 1981 · S/N 28-8190211 N8369YLand Sea Air LLC · West Tisbury, MAS/N 28-8190212 N8369ZB & J 58 Inc · Fredericksburg, VABuilt 1981 · S/N 28-8190213 N836ATDot Aviation LLC · Wilmington, DEBuilt 2012 · S/N 4496316 N836C36c Flights LLC · Ottawa Hills, OHS/N 1289 N836DSLima Hotel Aviation LLC · Mooresville, NCBuilt 2005 · S/N 40.500 N836EFLufthansa Aviation Training USA Inc · Goodyear, AZBuilt 2017 · S/N 2381 N836FSSmart01 LLC · Kissimmee, FLBuilt 1981 · S/N 28-8116200 N8370AIlich Randy Trustee · Ione, CABuilt 1981 · S/N 32R-8129059

Back to AD 2008-06-28 R1