Skip to content

AD 2008-06-28 R1

Registered aircraft · 16,284

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.

N855SKFx Energy Group LLC · Franktown, COBuilt 2006 · S/N 41700 N855TAWoods II Wings Aviation LLC · Oklahoma City, OKBuilt 2005 · S/N 1536 N8569QSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842404 N856DSInternational Air Services Inc Trustee · Carson City, NVBuilt 2007 · S/N 40.756 N856EFLufthansa Aviation Training USA Inc · Goodyear, AZBuilt 2018 · S/N 2434 N856JFCirrus Design Corp · Duluth, MNS/N 11763 N856KSKansas State University · Salina, KSBuilt 2022 · S/N 8749 N856NDHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1989 · S/N 4495001 N856PProfessional Training Aircraft LLC · Wilmington, DEBuilt 2018 · S/N 2843944 N856PUTrustees Of Purdue University · West Lafayette, INS/N 2881329 N856SRDavark Aero LLC · Grapevine, TXBuilt 2007 · S/N 2834 N8570FIxi LLC · West Bloomfield, MIBuilt 1976 · S/N 28-7790258 N8570RSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842405 N8571YSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842406 N8572ZSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842407 N8573JSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842408 N8574KSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842409 N8575WSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842410 N8576XSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842411 N8577YSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842412 N8578CRiver Valley Flyers LLC · West Hartford, CTBuilt 1976 · S/N 28-7690152 N8578ZSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842413 N857AZBb Air Group LLC · Aberdeen, SDBuilt 2005 · S/N 41078 N857CDAlbright J Trustee · Gold Canyon, AZBuilt 2002 · S/N 0271 N857GArcher Flight LLC · Wilmington, DEBuilt 2018 · S/N 2881068 N857PUTrustees Of Purdue University · West Lafayette, INS/N 2881330 N857SSjs Aviation Co · Casper, WYBuilt 1981 · S/N 28-8190224 N857SCFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881741 N857WAAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2004 · S/N 3257355 N857WDHangar Investments LLC · Sarasota, FLBuilt 2010 · S/N 4697432 N8580ESkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842414 N8581ASkyborne Airline Academy Inc · Vero Beach, FLBuilt 2024 · S/N 28020159 N8581JSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2015 · S/N 2842415 N8582ESkyborne Airline Academy Inc · Vero Beach, FLBuilt 2024 · S/N 28020160 N8583BSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2024 · S/N 28020201 N8584DSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2025 · S/N 28020202 N8585HSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2025 · S/N 28020232 N8586JSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2025 · S/N 28020233 N8587LSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2025 · S/N 28020234 N8588PSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2025 · S/N 28020235 N8589SSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2025 · S/N 28020249 N858ACConquest Enterprises Of Marquette LLC · Kingsford, MIBuilt 1983 · S/N 441-0321 N858BSSkye Co LLC · South Williamson, KYBuilt 2006 · S/N 2035 N858CAMgmb Aero LLC · Mandan, NDBuilt 2024 · S/N 10200 N858DASparti Aviation LLC · Simpsonville, SCBuilt 2021 · S/N 2766 N858DTUtah State University · Logan, UTS/N 40.748 N858HPJb Ag Lands LLC · Modesto, CAS/N 1968 N858MCRkh Capital LLC · Melbourne Beach, FLBuilt 2023 · S/N 9263 N858NDAero Assurance Services LLC Trustee · Yakima, WAS/N 41652 N858PAPodhajsky Nicholas P · Traer, IAS/N 40.258

Back to AD 2008-06-28 R1