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.

N81HPFly Buys Too LLC · Wilmington, DEBuilt 1973 · S/N LW-72 N81MMMangum Aviation Inc · Pasadena, TXBuilt 1980 · S/N 28-8090332 N81NXEagle Aero Aviation LLC · Lewes, DEBuilt 2007 · S/N 2660 N81PKTier-1 Helicopters LLC · Hampton, GAS/N 3213023 N81PNFreseman Christine · Redding, CABuilt 1978 · S/N 441-0037 N81PVBrighton Vista LLC · Rockaway Beach, ORBuilt 2016 · S/N 4433 N81TFA P A C LLC · Berlin, NJBuilt 1980 · S/N BB-750 N81TLC S & P Rocky Mountain Inc · Cheyenne, WYS/N BB-959 N81WFWolf Capital LLC · Forest, VABuilt 2006 · S/N 1772 N820Ames Air LLC · Mechanicsville, VABuilt 2008 · S/N 3305 N82005S&H Leasing LLC · Sarasota, FLBuilt 1981 · S/N 28-8116286 N82008Craige Danny D Trustee · Durant, OKBuilt 1980 · S/N 32R-8029089 N8200VHills Holding · Newark, DEBuilt 1980 · S/N 28-8016319 N8200ZFlack Norma Jeanne · Fort Lauderdale, FLBuilt 1980 · S/N 28-8016320 N8202ERegistered aircraftBuilt 1982 · S/N 32R-8313014 N8203DVans Holding LLC · Canton, OHBuilt 1982 · S/N 28-8290120 N8203TSky Duchess LLC · Minette, ALS/N 32R-8229049 N8203XLillieaire LLC · Olive Branch, MSS/N 34-8333029 N82044Chandler Air Service Inc · Chandler, AZBuilt 1982 · S/N 28-8216156 N82045Paris Air Inc · Vero Beach, FLBuilt 1982 · S/N 28-8216157 N82048Newton Property Leasing LLC · Greene, IABuilt 1982 · S/N 28-8290127 N8204JKusa Aviation LLC · Beaumont, TXBuilt 1982 · S/N 28-8216154 N82054Fusaro Ronald G · Westerly, RIBuilt 1982 · S/N 28-8390033 N8205APilot Place LLC · Sarasota, FLBuilt 1983 · S/N 28-8316048 N8205EChandler Air Service Inc · Chandler, AZBuilt 1982 · S/N 28-8290129 N8205GYoung Charles D · Athens, TXBuilt 1982 · S/N 28-8290130 N8206HJonathan Designs Inc · Cape Coral, FLBuilt 1982 · S/N 32R-8213046 N82073D K Engineering LLC · Sioux City, IABuilt 1982 · S/N 34-8233120 N82075Miloud Chadd K · Fort Worth, TXBuilt 1982 · S/N 28-8216158 N82085Read Lawton · Meredith, NHS/N 28-8290132 N82097Argosy Venture Corporation · Pagosa Springs, COBuilt 1982 · S/N 32R-8229052 N8209EAnywhere Atp LLC · Mount Juliet, TNBuilt 1983 · S/N 28-8316027 N820AMWolsey Gilman T · Scottsdale, AZBuilt 2007 · S/N 40.880 N820BKKamberi Aviation LLC · Hyannis, MABuilt 2025 · S/N 10866 N820CSAmcs LLC · Pembroke Pines, FLS/N 1985 N820DSTino Equipment LLC · Salisbury, NCBuilt 2007 · S/N 40.893 N820FWN820fw LLC · Grand Rapids, MIBuilt 2011 · S/N 3798 N820GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881466 N820LWLance R Ward Enterprises Inc · Geneva, NYBuilt 2005 · S/N 1660 N820NDUniversity Of North Dakota · Grand Forks, NDBuilt 2018 · S/N 2881048 N820RDImhof Air 2 LLC · Ferndale, WABuilt 1973 · S/N LW-82 N820SRCannoles Ronald I · Las Vegas, NVBuilt 2007 · S/N 2463 N820TSSr820 LLC · Nashville, TNBuilt 2018 · S/N 4607 N820WMArchangel Two LLC · Lewes, DEBuilt 1977 · S/N 28-7890295 N8210EPowell Samuel C · Burlington, NCBuilt 1982 · S/N 32R-8229053 N8210HSlap Shot Aviation LLC · Parker, COBuilt 1982 · S/N 32R-8229054 N8210ZFlymore Inc · Kawkawlin, MIBuilt 1982 · S/N 28-8290136 N82118Eagle Aeronautics LLC · Chicago, ILBuilt 1982 · S/N 28-8290138 N8211SKowitz Alfred R · Semora, NCBuilt 1980 · S/N 28-8090301 N8211THartmann Michael B · Newberg, ORBuilt 1980 · S/N 28-8090302

Back to AD 2008-06-28 R1