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.

N808HWManu Aircraft LLC · Kihei, HIBuilt 2007 · S/N 2877 N808KBAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2005 · S/N 1477 N808KMCti Aircraft Leasing LLC · Memphis, TNS/N 2881301 N808LASouth Bound Holdings LLC · Knoxville, TNBuilt 2008 · S/N 4697392 N808MSAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2007 · S/N 2355 N808TAMos Aviation LLC · Duluth, MNBuilt 2025 · S/N 10612 N808TFAir Fleet Holdings LLC · Missoula, MTBuilt 2024 · S/N 2881701 N808WYTriple B Aviation LLC · Kalispell, MTBuilt 2012 · S/N 4636536 N80908International Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N 28-8016074 N8090ELeslie H Mcelhany DBA · Watertown, SDBuilt 1979 · S/N 28-8016072 N8090FDouglas Malik · Mcdonough, GABuilt 1976 · S/N 28-7790233 N8090LWilliams Chris B · Reno, NVBuilt 1979 · S/N 28-8090092 N8090TN8090t LLC · Austin, TXBuilt 1979 · S/N 32R-8029020 N8091RParis Air Inc · Vero Beach, FLBuilt 1979 · S/N 28-8016077 N8091YStevens Charles R · Williamsburg, MIBuilt 1979 · S/N 28-8016079 N80926Flight Leasing Corp · Wilmington, DEBuilt 1979 · S/N 28-8090098 N8092ERaleigh Flying Club LLC · Chapel Hill, NCBuilt 1979 · S/N 28-8090093 N8092GEarly Stephen · Sharpsburg, GABuilt 1979 · S/N 28-8090095 N8092HUnited States Air Force Owner · Hanscom Afb, MABuilt 1979 · S/N 28-8016082 N80934Cogelia Joseph M · Winchester, VABuilt 1979 · S/N 28-8090105 N8093GFargo Jet Center LLC · Fargo, NDBuilt 1979 · S/N 28-8090100 N8093HSarraf Majid · Aliso Viejo, CABuilt 1979 · S/N 28-8090101 N8094AMuhlenberg Barry Vk · Pottstown, PABuilt 1982 · S/N 32R-8213030 N80964Three Wing Flight School LLC · Stratford, CTBuilt 1981 · S/N 28-8216108 N80968Wisconsin Aviation Inc · Watertown, WIBuilt 1979 · S/N 28-8016087 N8096HCic Aviation LLC · Wenatchee, WABuilt 1982 · S/N 34-8233083 N8096JBullgoose Aviation Inc · York, PANon-citizen corporation, flight hours not reportedBuilt 1979 · S/N 32R-8029006 N8096QHoover Charles J · Logansport, INBuilt 1981 · S/N 28-8216107 N8096SFreedom Aircraft Jv 1 LLC · Milton, FLBuilt 1979 · S/N 32R-8013006 N8096VPlatt Philip L · Concho, AZBuilt 1979 · S/N 32R-8013007 N8097HMiloud Chadd K · Fort Worth, TXBuilt 1979 · S/N 28-8016092 N8097JAjdari Rodmehr · Millville, NJBuilt 1979 · S/N 28-8016093 N8097PEmery Jonathan D · Payson, AZBuilt 1979 · S/N 28-8090106 N8097QHissey Mark E · Fannettsburg, PABuilt 1980 · S/N 28-8090107 N8097SBrookwood Plastering Inc · San Diego, CABuilt 1979 · S/N 28-8090108 N8098BIowa Aircraft Inc · Burlington, IABuilt 1979 · S/N 28-8090110 N8098MRock Solid Aviation LLC · Lake Charles, LABuilt 1979 · S/N 28-8090111 N809AMWelbourn Farms Inc · Union City, OHBuilt 2007 · S/N 40.809 N809ASHaack Gregory · Signal Hill, CABuilt 2008 · S/N 3191 N809CJl & R Aviation LLC · Hays, KSBuilt 2010 · S/N 4636485 N809CDDelaware Resources LLC · Wilmington, DES/N 0117 N809CV1876 Holdings LLC · Canyon, TXBuilt 2020 · S/N 2590 N809DMAir Reldan Inc · Slidell, LABuilt 1980 · S/N LW-334 N809DSCook Michael R · Forest, VABuilt 2004 · S/N 0998 N809JNMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 2025 · S/N 10659 N809LTLae Aviation LLC · Ragley, LABuilt 2015 · S/N 4176 N809MTBank Of Utah Trustee · Salt Lake City, UTBuilt 2022 · S/N 8915 N809NGMcshane Family Aviation LLC · Harrisburg, PABuilt 2026 · S/N 11437 N809PCSierra Juliet Aviation LLC · Murfreesboro, TNBuilt 2012 · S/N 3849 N809PSP & P Air LLC · Wilmington, DEBuilt 1978 · S/N BB-339

Back to AD 2008-06-28 R1