Skip to content

AD 2008-06-28 R1

Registered aircraft · 16,284

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.

N838DHGcbc LLC · Norman, OKBuilt 1979 · S/N 28-7916247 N838EFLufthansa Aviation Training USA Inc · Goodyear, AZBuilt 2017 · S/N 2386 N838GGirus Cirrus Inc Trustee · Wilmington, DEBuilt 2009 · S/N 3524 N838MACca Aero Estate LLC · Missoula, MTS/N 28-7916019 N838PProfessional Training Aircraft LLC · Wilmington, DEBuilt 2018 · S/N 2843941 N838RJDicky David J · Sierra Vista, AZS/N 34-8133089 N838VKHepburn Joseph · Towanda, KSBuilt 2007 · S/N 42559 N838WPHeartland Air Leasing LLC · Coon Rapids, MNBuilt 2017 · S/N 4444 N8390CArserio Gregory J · Fairport, NYBuilt 1976 · S/N 28-7690130 N83914Upstate Aviators LLC · Spartanburg, SCBuilt 1981 · S/N 28-8290036 N8391QGambel E Anthony · Sewanee, TNBuilt 1981 · S/N 28-8116233 N8391SVip Medical Services LLC · Nixa, MOBuilt 1981 · S/N 28-8116234 N8391YSchafer Gary L · Greenwood, DEBuilt 1981 · S/N 28-8116235 N83924Moseley Barton S · Tomball, TXBuilt 1981 · S/N 32R-8113070 N83932Mike Sierra Aviation LLC · Fort Worth, TXBuilt 1981 · S/N 34-8133111 N8393AMyhre Real Estate Management Inc · Rochester, NHBuilt 1981 · S/N 32R-8113071 N8393CAndersen Robin L · Cloverdale, CABuilt 1976 · S/N 28-7690131 N8393GRegistered aircraftBuilt 1981 · S/N 32R-8113072 N8393XAeroforge LLC · Crystal Lake, ILBuilt 1981 · S/N 32R-8129074 N8393YPars Avn Corp · Wilmington, DEBuilt 1981 · S/N 34-8133108 N83947Iziair LLC · Mclean, VAFirst renewal noticeBuilt 1981 · S/N 28-8190247 N8394ANew Orleans Aviation LLC · Slidell, LABuilt 1981 · S/N 34-8133114 N8394CThree Rivers Aero LLC · Three Rivers, MIBuilt 1976 · S/N 28-7690132 N8394DTrident Aircraft Inc · Easton, MDBuilt 1981 · S/N 28-8116238 N8394YGadamic LLC · Fresno, CABuilt 1981 · S/N 28-8190246 N8395APrecision Drilling Services LLC · Honolulu, HIBuilt 1981 · S/N 28-8190248 N8395CN8395c LLC · Peachtree City, GABuilt 1976 · S/N 28-7690133 N8395HApple X05 LLC · Spring Hill, FLBuilt 1981 · S/N 28-8190249 N83960Paris Air Inc · Vero Beach, FLBuilt 1981 · S/N 28-8116244 N8396JCurtsinger Joseph C Jr · Nolensville, TNBuilt 1981 · S/N 32R-8129075 N8396LEmerald Coast Aircraft LLC · Panama City Beach, FLBuilt 1981 · S/N 28-8190288 N8396ZSaflite Pilot Training Inc · Hooksett, NHS/N 28-8116243 N83974Otoole Airways LLC · Great Neck, NYBuilt 1981 · S/N 28-8190254 N8397LWingsleasing LLC · Wichita, KSBuilt 1981 · S/N 28-8190252 N83988Frese Dental LLC · Birmingham, ALBuilt 1981 · S/N 32R-8113080 N83993Brandywine Flight School · West Chester, PABuilt 1981 · S/N 28-8216007 N8399AL C Shearer LLC · Battle Ground, WABuilt 1981 · S/N 34-8133130 N839ALHorizon Dreams LLC · Homer, GABuilt 2000 · S/N 2843412 N839ATAtp Taa LLC · Wilmington, DEBuilt 2023 · S/N 4496565 N839CTFast Flyers Aviation Partners LLC · Leawood, KSBuilt 2008 · S/N 2938 N839DXPiper Aircraft Inc · Vero Beach, FLBuilt 2024 · S/N 2881825 N839EFLufthansa Aviation Training USA Inc · Goodyear, AZBuilt 2017 · S/N 2387 N839SR839sr LLC · Rocky Mount, NCBuilt 2007 · S/N 2726 N839WXBezner Partners LLC · Texline, TXBuilt 2004 · S/N 1154 N83A441 LLC · Sioux Falls, SDBuilt 1978 · S/N 441-0050 N83CDRegistered aircraftBuilt 2003 · S/N 1301 N83ECCarter Associates Inc · Sturgis, MIBuilt 2000 · S/N 4636307 N83FEG&C Aviation LLC · Wilmington, DEBuilt 1977 · S/N LW-219 N83FLHoopoes Holding LLC · Newton, MABuilt 2026 · S/N 11340 N83GTChambliss Aerobatics LLC · Chandler, AZBuilt 2001 · S/N 46-97032

Back to AD 2008-06-28 R1