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.

N8152TDud Stud Aviation LLC · Bremen, GABuilt 2003 · S/N 0696 N8152XFly Dc Air LLC · Plantation, FLBuilt 2003 · S/N 0686 N8153HT Money Aviation LLC · St George, UTBuilt 2003 · S/N 0702 N8153JHand Peter J · Princeton, NJBuilt 2003 · S/N 1366 N8153RPleasantwood Corp · North Canton, OHS/N 0708 N8153VRed River Leasing LLC · Memphis, TNBuilt 2003 · S/N 0709 N8154JCarter Flygare Inc · Sacramento, CABuilt 1980 · S/N 44-8095020 N8155GSaraceno Robert Jr · Lynnfield, MABuilt 1980 · S/N 28-8090237 N8155HPeckerhead Motorcycle Racing LLC · Gainesville, GABuilt 1982 · S/N 28-8290101 N8156RGhazarian Christopher L · North Hollywood, CABuilt 1979 · S/N 28-8016156 N8156TAzcona Rogelio G · Okeechobee, FLBuilt 1979 · S/N 28-8016219 N81579Reddout Richard L · Tupelo, MSS/N 32R-8213037 N8157ZJordahl Shawn · Motley, MNBuilt 2003 · S/N 1377 N81586Elbarki Maged A · Boca Raton, FLBuilt 1980 · S/N 28-8090245 N8158BRegistration Pending · Springfield, MORegistration pendingS/N 32R-8229038 N8158HLopez-Haley LLC · Mc Afee, NJS/N 28-8016268 N8158ZLee Randy A · Gulf Shores, ALBuilt 1980 · S/N 28-8016269 N81593Krueger Carl M · Kelleys Island, OHBuilt 1980 · S/N 32R-8013044 N8159SGaither David G Executor · Houston, TXS/N 32R-8029059 N8159YRaven Aviation LLC · Murrayville, GABuilt 1980 · S/N 32R-8029060 N815ATSeminole Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 4496533 N815CDHotrod Aviation LLC · Greencastle, INS/N 0149 N815CFMeridian Air LLC · New Boston, MIBuilt 2006 · S/N 4697242 N815DBR&R Daredevils LLC · Wilmington, DEBuilt 2011 · S/N 3743 N815DFOglesby Richard A Jr · Atlanta, GABuilt 1999 · S/N 2843295 N815DSFlt Academy · Woods Cross, UTBuilt 2007 · S/N 40.815 N815DXGlobe Aero LLC · Lakeland, FLBuilt 2025 · S/N 2881839 N815HCHci Leasing Inc · Merritt Island, FLBuilt 2004 · S/N 1199 N815JDBuilders Aviation LLC · Algona, IABuilt 2003 · S/N 0543 N815MLStover Joanne · Westlake Village, CABuilt 2019 · S/N 2500 N815TFAir Fleet Holdings LLC · Missoula, MTS/N 2881703 N8160CDoor To Door Express LLC · Middletown, DEBuilt 2003 · S/N 1381 N8160HRegistered aircraftBuilt 1980 · S/N 32R-8013062 N8160NDiehl Edwin L III Trustee · Scio, ORS/N 0734 N8160QAbaco Express Logistics LLC · Orlando, FLBuilt 1980 · S/N 32R-8013063 N81612Av8rlounge LLC · Columbia, SCBuilt 1980 · S/N 28-8016270 N8161DDicey Aviation LLC · Somerset, KYBuilt 1980 · S/N 28-8016220 N8162ADedominici Kenneth · East Bridgewater, MABuilt 1980 · S/N 28-8016272 N8162QMcconnell Thomas R · St Simons Island, GABuilt 1980 · S/N 28-8090251 N8162RNoyes Daniel Ernest · Burton, MIBuilt 1980 · S/N 28-8090252 N8162TSobhi Air LLC · Aldie, VABuilt 2003 · S/N 0740 N8163RFoothills Insurance Services LLC · Marion, NCBuilt 2003 · S/N 0744 N8163SDilouis Andre J · West Deptford, NJBuilt 1980 · S/N 28-8016277 N8163THeuschele Michael C · Foristell, MOBuilt 1980 · S/N 28-8090253 N8163VPerleberg Patrick M · Cedar Grove, INBuilt 2003 · S/N 0748 N8163YBachman David R · Chisago City, MNBuilt 1980 · S/N 28-8090254 N8164DRowe Richard D · Corpus Christi, TXBuilt 1982 · S/N 34-8233086 N8164FVander Ark Jan R Trustee · Chandler, AZBuilt 2003 · S/N 0749 N8164XVenus USA · Gainesville, FLS/N 0733 N8165GSkychaser LLC · Green Brook, NJS/N 28-8216127

Back to AD 2008-06-28 R1