Registered aircraft · 16,295

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.

N139MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2022 · S/N 4496541 N139PSIn-Site Aviation LLC · American Fork, UTBuilt 2005 · S/N 40.518 N139RRRyan Renae L Trustee · Wichita, KSBuilt 1976 · S/N BB-177 N13ANFreedom Okc Aircraft LLC · Oklahoma City, OKBuilt 2024 · S/N 10064 N13AUCirrus Design Corp · Duluth, MNS/N 11745 N13DAD&J Training Planes LLC · Logan, UTBuilt 2020 · S/N 40.1210 N13HEVam LLC · Bloomfield Hills, MIBuilt 2008 · S/N 411075 N13KHPoppy State Ventures LLC · West Hollywood, CABuilt 2025 · S/N 10650 N13MLM3l LLC · Smyrna, TNBuilt 2007 · S/N 2573 N13MYTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2021 · S/N 2778 N13NWCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1979 · S/N 441-0090 N13PYMartinez De Garcia Linda M · Miami, FLBuilt 2012 · S/N 3872 N13WStl LLC · Savoy, ILBuilt 2001 · S/N 3246185 N13WRBillys Blessing LLC · Louisburg, NCBuilt 2000 · S/N 3246154 N1401WLewes Adventures LLC · Wilmington, DEBuilt 2007 · S/N 41644 N1403CPinger Kevin · Palo Alto, CABuilt 2003 · S/N 0519 N1404HMiller Shawn C · Milaca, MNS/N 28-7716023 N1408WLate10air LLC · Fullerton, CABuilt 2015 · S/N 4243 N140AFBoard Of Trustees Of Western Michigan University · Battle Creek, MIBuilt 2006 · S/N 1709 N140BVGlobal Jetcare Inc · Brooksville, FLBuilt 2011 · S/N 3780 N140CDCirrus Design Corp · Duluth, MNBuilt 2001 · S/N 1023 N140DKIsland Flight Services LLC · Hauppauge, NYBuilt 2009 · S/N 2029 N140FCDepartment Of Agriculture & Consumer Services · Tallahassee, FLBuilt 1982 · S/N 28-8290175 N140NDCoco Aircraft Inc · Merritt Island, FLBuilt 1989 · S/N 2841206 N140RLN140rl LLC · Kalispell, MTBuilt 1982 · S/N BT22 N14100Ycb Wings LLC · Tavares, FLBuilt 2006 · S/N 41663 N1411GTd Investments LLC · Oakdale, CAS/N 42556 N1415KColumbia N1415k LLC · Leesburg, INBuilt 2006 · S/N 42547 N1416RSkyhawk LLC · Great Falls, VABuilt 2020 · S/N 4975 N1417WInternational Air Services Inc Trustee · Carson City, NVS/N 42523 N141AVMavity Michael D · Phoenix, AZBuilt 1984 · S/N 28-8490107 N141DDCox Aviation Services LLC · Acworth, GABuilt 1999 · S/N 3246132 N141ECDcomm Inc · Austin, TXBuilt 2007 · S/N 2556 N141FCDepartment Of Agriculture & Consumer Services · Tallahassee, FLBuilt 2019 · S/N 2881158 N141FQCross Daniel · Windham, NHS/N 28-8290176 N141HLSynchronistic Operations Solutions LLC · Richmond, VABuilt 2010 · S/N 40.1079 N141HTBazman Aviation LLC · Harbor Springs, MIBuilt 2006 · S/N 2219 N141PBL&M Columbia 181 LLC · Chandler, AZS/N 42066 N141PGIshikawa Brendon · Davis, CABuilt 2008 · S/N 1921 N141SBCk Aviation LLC · Bismarck, NDBuilt 1999 · S/N 4636244 N141WAJohnston James E · Fernandina Beach, FLBuilt 1980 · S/N 28-8116135 N1422TRead Travis · Lumberton, TXBuilt 1982 · S/N 34-8133277 N1423ABijur David · Truckee, CAFirst renewal noticeBuilt 2007 · S/N 41719 N1423CGlovis Mark S · Wyandotte, MIBuilt 2003 · S/N 1318 N142AKCirrus Design Corp · Duluth, MNS/N 11885 N142BKCirrus Sr22 11508 Inc Trustee · Wilmington, DEBuilt 2026 · S/N 11508 N142CGlc Equipment Leasing LLC · Paragould, ARBuilt 2018 · S/N 4714 N142CWTable Rock Aviation Inc · Galena, MOBuilt 2006 · S/N 1911 N142DCirrus Design Corp · Knoxville, TNBuilt 2017 · S/N 4587 N142EEHound Dog Aircraft LLC · Lawrence, KSBuilt 2005 · S/N 4697217

Back to AD 2008-06-28 R1