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.

N30117D & S Aviation LLC · Spring, TXBuilt 1978 · S/N 28-7916077 N3011WHall Larry C · Decatur, ALBuilt 1996 · S/N 28-43065 N3011ZBoe Arvid J · Langdon, NDBuilt 1979 · S/N 28-7916393 N30126Pilots Choice Aviation Equipment Leasing Co · Georgetown, TXBuilt 1978 · S/N 28-7990084 N3012ABottoms Engineering & Service Inc · Frankfort, KYBuilt 1978 · S/N 28-7990112 N3012DArias Herman R · Waco, GAS/N 28-7916154 N3013DMcclary Doug T · South Lyon, MIBuilt 1978 · S/N 28-7990170 N3013ZZakos Dean R · Middleton, WIBuilt 1979 · S/N 28-7916395 N30144Roberti Aviation Of Delaware Inc · Lighthouse Point, FLS/N 3257330 N30147G&M Aircraft Inc · Wheat Ridge, COBuilt 1978 · S/N 28-7990085 N3014CAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 2007 · S/N 4697311 N3014HBad Dog Aviation Inc · Meridianville, ALBuilt 1978 · S/N 28-7916182 N3015DFlywell Flying Club Inc · Roseville, MNBuilt 1978 · S/N 28-7990171 N3015UCoastal Fliers Inc · El Cajon, CABuilt 1979 · S/N 28-7990335 N3016MWild Wingdom LLC · Greenville, SCBuilt 1978 · S/N 28-7890284 N3016TWilson Michael L · Santa Maria, CABuilt 1979 · S/N 28-7916298 N3017HDavis Ronald C · Bloomington, MNS/N 28-7916184 N3018ZGorman Robert L · Los Gatos, CABuilt 1979 · S/N 28-7916398 N301BHTraxler Shane C · West Monroe, LABuilt 1997 · S/N 3246080 N301BLPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020284 N301DSInternational Air Services Inc Trustee · Carson City, NVBuilt 2013 · S/N 40.1177 N301ECF N A Aviation LLC · Wakefield, MABuilt 2025 · S/N 2881980 N301FBlue Sky November LLC · Mamaroneck, NYBuilt 2026 · S/N 11303 N301FCTango Charlie Aviation LLC · Thomasville, GABuilt 2023 · S/N 9076 N301GValiair Lc Trustee · Casper, WYBuilt 2008 · S/N 1970 N301GKBrown Water Associates LLC · Monticello, FLBuilt 2020 · S/N 4951 N301JPAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2007 · S/N 2240 N301KARivard Robert M · Grand Haven, MIBuilt 1981 · S/N 32R8113020 N301KG217 Aviation LLC · Winchester, ILBuilt 1988 · S/N 3213017 N301MDMoritz Davis Aviation LLC · Edina, MNBuilt 2009 · S/N 3484 N301RTSather Dean L · Amarillo, TXBuilt 1982 · S/N 32R-8229068 N301RVK6 Construction Inc · Clovis, CABuilt 2004 · S/N 1172 N301SEAmerican Air Academy Inc · Merritt Island, FLBuilt 2004 · S/N 3449304 N301TCSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2001 · S/N 3257257 N301VSStellina Aviation LLC · Tulsa, OKBuilt 2023 · S/N 9319 N301WYOrion Air Holdings LLC · Cheyenne, WYS/N BB-476 N3020MWifa (Washington International Flight Academy) LLC · Gaithersburg, MDBuilt 1979 · S/N 44-7995220 N3020SAndre Frazier LLC · Anacortes, WABuilt 1979 · S/N 28-7916295 N3021CUnited States Air Force Owner · Hanscom Afb, MABuilt 1978 · S/N 28-7916137 N3021HWilcox Kenneth P · Peachtree City, GABuilt 1978 · S/N 28-7990200 N30222Nass Aviation Inc · Selbyville, DEBuilt 1978 · S/N 28-7990086 N30230N30230 Aircraft Holdings LLC · North Charleston, SCBuilt 1978 · S/N 28-7990088 N3023CBlack Cloud Aviators Inc · Dubois, PABuilt 1978 · S/N 28-7990148 N3023TInternational Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N 28-7916299 N30249Campbell Donald R · Lawrenceburg, KYBuilt 1978 · S/N 28-7890451 N3024CCash Management Consulting LLC · Granite Springs, NYBuilt 1978 · S/N 28-7990149 N3024MTremie Chad M · Sulphur, LABuilt 1977 · S/N 28-7890286 N3025CWonnenberg Douglas D · Menoken, NDBuilt 1978 · S/N 28-7990150 N3025QTamborelli Keith · Kulpmont, PABuilt 1979 · S/N 28-7916285 N30260Schubert Mark J · Watkins, COBuilt 1978 · S/N 28-7890452

Back to AD 2008-06-28 R1