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.

N215EVSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1984 · S/N 348533002 N215FWAtp Aircraft 2 LLC · Wilmington, DES/N 447995056 N215JPPilot Peak Adventures LLC · Ely, NVBuilt 2007 · S/N 2493 N215MEMaine Instrument Flight · Augusta, MEBuilt 2023 · S/N 9528 N215PASouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 4697347 N215RRRednor Jeffrey · Yardley, PABuilt 2005 · S/N 1448 N215SDEastern Stearman Inc Trustee · Leesburg, VABuilt 2001 · S/N 4697049 N215SRDkm Aviation LLC · Dawsonville, GABuilt 2006 · S/N 1680 N215UParagon Airplane Leasing Co · Fort Myers, FLBuilt 2023 · S/N 28020136 N215VSBellue Barry Lee · Jackson, LABuilt 2003 · S/N 1334 N215ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881607 N21605Chandler Air Service Inc · Chandler, AZBuilt 1978 · S/N 28-7990054 N2162KApm Leasing LLC · Casper, WYBuilt 1978 · S/N 44-7995198 N2163FSkywarrior Flight Training Inc · Pensacola, FLBuilt 1978 · S/N 44-7995167 N2163GWilson Willard III · Cannon Falls, MNBuilt 1978 · S/N 28-7990194 N2164GAulton New Energy Inc · Monterey, CABuilt 1978 · S/N 28-7990195 N2165BCondor LLC · Cumberland, RIBuilt 1978 · S/N 28-7990122 N2165HQuin Air Inc · Shreveport, LABuilt 1978 · S/N 28-7990210 N2166BScroggs Ross A · Locust Grove, GABuilt 1978 · S/N 28-7990123 N2166FUniversity Of Oklahoma · Norman, OKBuilt 1978 · S/N 28-7916208 N2166LNefc Inc · North Andover, MABuilt 1979 · S/N 28-7990259 N2169FBrolan Aviation LLC · Kansas City, MOBuilt 1978 · S/N 28-7990222 N216AMAirmart Inc · Lexington, KYS/N 2881092 N216DGSky Safety Inc · San Antonio, TXBuilt 2006 · S/N 40.698 N216DHRebel One LLC · Dover, DEBuilt 2015 · S/N 4270 N216DKMares Tails Holdings Inc · Manchester, NHBuilt 2012 · S/N 2150 N216FWAtp Aircraft 2 LLC · Wilmington, DEBuilt 1979 · S/N 447995181 N216GTFlying Cow LLC · Jenks, OKBuilt 2007 · S/N 40.819 N216LBell John · Linville, NCBuilt 2004 · S/N 1111 N216MAPatriot Flight LLC · Bartlesville, OKBuilt 1995 · S/N 3246016 N216MMCirrusly LLC · Santa Monica, CABuilt 2026 · S/N 11278 N216NGrb Aircraft Leasing LLC · West Fargo, NDBuilt 2008 · S/N 3117 N216PBDivine Air LLC · Brookshire, TXBuilt 2025 · S/N 10924 N216PWPapa Whiskey LLC · Chicago, ILBuilt 2002 · S/N 3257304 N2170FSwaney Dustin F · Hayes, VABuilt 1978 · S/N 28-7990223 N2170NCottle Dennis J · Bainbridge Island, WABuilt 1979 · S/N 44-7995224 N21717Newton Andrew A · Mount Sterling, ILBuilt 1978 · S/N 28-7990058 N2171YForbes Aviation LLC · Boise, IDBuilt 1979 · S/N 28-7990380 N2172DWifa (Washington International Flight Academy) LLC · Gaithersburg, MDBuilt 1978 · S/N 28-7916147 N21730Erickson Lauren A · Portland, NDBuilt 1978 · S/N 28-7916024 N2173SSunrise Aviation Inc · Ormond Beach, FLBuilt 1979 · S/N 44-7995245 N2174EHans Aviation Inc · Davie, FLBuilt 1978 · S/N 28-7916164 N2174XBennett Milton J · Gig Harbor, WABuilt 1979 · S/N 28-7990362 N2175NVenezia Domenick · Shoreline, WABuilt 1979 · S/N 28-7916262 N2176XKnighten Daniel · Portland, ORBuilt 1979 · S/N 28-7990363 N2178YN2178y LLC · Cumming, GABuilt 1979 · S/N 28-7990381 N217BBChudik Martin · Acton, MABuilt 2000 · S/N 1036 N217CDCornett Hiram D · Muldraugh, KYBuilt 2000 · S/N 1091 N217CEHardgrave Kenneth K · Texas City, TXBuilt 2011 · S/N 3812 N217CFN47hy LLC · New York, NYBuilt 2005 · S/N 40.584

Back to AD 2008-06-28 R1