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.

N217CMKlas-Kcoe LLC · Las Vegas, NVBuilt 1980 · S/N BB-621 N217CPAlbie Air LLC · Wake Forest, NCS/N 3147 N217ETAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2010 · S/N 3637 N217GMMarcom Michael D · Valley View, TXBuilt 2010 · S/N 3688 N217JHHahn Jonathan · The Villages, FLBuilt 2003 · S/N 1320 N217MCCnj Aviation LLC · Cooper City, FLBuilt 2026 · S/N 11173 N217MLDodson Intl Parts Inc · Rantoul, KSS/N BB739 N217SLJ & J Aviation LLC · Lafayette, LABuilt 2017 · S/N 4539 N217SRAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2006 · S/N 2118 N217SWMountain Lion Aviation LLC · Truckee, CABuilt 2025 · S/N 10680 N217TJBb Air LLC · Fayetteville, NCBuilt 2006 · S/N 2291 N217TSLaukatel Air Inc Trustee · Wilmington, DEBuilt 1998 · S/N 4636144 N217TXLong Jeffrey E · Dothan, ALBuilt 1997 · S/N 3246070 N217VASouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 3257492 N21802Owen Michael C · Seaside, CABuilt 1978 · S/N 28-7990059 N21803Morgan Edward · Gaithersburg, MDBuilt 1978 · S/N 28-7990060 N2180EInternational Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N 28-7916165 N2180YAstro Aviation LLC · Cross Plains, TNBuilt 1979 · S/N 28-7990383 N2181BJao Robert V · Kailua, HIBuilt 1978 · S/N 28-7916114 N2182BFlying 20 Club Inc · Springfield, ILBuilt 1978 · S/N 28-7990124 N2182QCassett Terry D · Mankato, MNBuilt 1979 · S/N 28-7990297 N2183DLyons Terry L · Springfield, ILBuilt 1978 · S/N 28-7990163 N2184BPlane Nonsense Inc · Middletown, DEBuilt 1978 · S/N 28-7990125 N21857Top Air · Salt Lake City, UTBuilt 1978 · S/N 28-7990062 N2185BHeirborne Again LLC · West Bridgewater, MABuilt 1978 · S/N 28-7990126 N2185XHendricks Robert H · Chico, CABuilt 1979 · S/N 28-7990366 N21866Donthineni Rakesh · Oakland, CABuilt 1978 · S/N 28-7990063 N2189QBlue Hen Aviation Services LLC · Easton, PABuilt 1979 · S/N 28-7990298 N2189ZWeltin Gregory G · Kennebunk, MEBuilt 1981 · S/N 28-8190285 N218APPeterson Jeff W · Bristol, MES/N 41731 N218AZZavaleta Eric · Abilene, TXBuilt 2008 · S/N 3257486 N218CDRegistered aircraftBuilt 2001 · S/N 1123 N218CLBlue Diamond Marketing LLC · Hoover, ALBuilt 2011 · S/N 40.1129 N218DCGammons Leasing LLC · North Charleston, SCBuilt 2008 · S/N 40.965 N218DFHuff Technologies · Morganfield, KYBuilt 2006 · S/N 1688 N218DPSmb Consulting And Investing LLC · Jamison, PABuilt 2006 · S/N 1800 N218DSCapital Holdings 201 LLC · Waynesboro, PABuilt 2008 · S/N 40.951 N218EMAir Travel & Transportation Services LLC · Atlantic Beach, FLBuilt 2007 · S/N 2511 N218GCCirrus Design Corp · Duluth, MNS/N 11680 N218JSSluss Air LLC · Manhattan Beach, CABuilt 2022 · S/N 8551 N218KKSkymates Inc · Wilmington, DEBuilt 2002 · S/N 4496153 N218LJFoster James L · Bryan, TXBuilt 2007 · S/N 2673 N218LMKrause Cody · Clear Lake, SDBuilt 2003 · S/N 0501 N218MNSkyking Investments LLC · Duluth, MNBuilt 2019 · S/N 2499 N218PM218pm LLC · Fort Collins, COBuilt 2002 · S/N 0201 N218SRTs Joyce Aviation LLC · West Fargo, NDBuilt 2006 · S/N 2074 N218WLN218wl LLC · Marshalltown, IABuilt 2004 · S/N 40.387 N218WSOrourke Brendan W · Stoughton, WIBuilt 1979 · S/N 28-8090094 N218WTAirflo Aviation LLC · Banner Elk, NCBuilt 2014 · S/N 4036 N218XBulzan Lawrence Mitchell · Concord Township, OHBuilt 2004 · S/N 1134

Back to AD 2008-06-28 R1