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.

N622BW622bw LLC · Alpharetta, GABuilt 2023 · S/N 9156 N622CCool Plane LLC · Jackson, TNBuilt 2002 · S/N 0368 N622CCYale Companies LLC DBA · Indianapolis, INBuilt 2021 · S/N 2881514 N622CPGarlow Insurance Agency Inc · Chesapeake, VABuilt 2008 · S/N 1932 N622DAJett Aviation LLC · Wilmington, DEBuilt 2008 · S/N 1900 N622DMRodgers Raymond S · Fredericksburg, TXBuilt 2006 · S/N 1810 N622DSMidwest Corporate Air Inc · Bellefontaine, OHBuilt 2006 · S/N 40.612 N622DTAugusta Aviation Inc · Hilton Head, SCBuilt 2010 · S/N 2069 N622HJVictor Hotel LLC · Houston, TXBuilt 2011 · S/N 2079 N622JBSun Aircraft Management LLC · Ormond Beach, FLBuilt 1978 · S/N 44-7995080 N622KMK & M Equipment Co LLC · Chatsworth, CABuilt 1981 · S/N BB-491 N622MTDms Buffalo LLC · Buffalo, NYBuilt 2022 · S/N 8697 N622NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2019 · S/N 2881160 N622PDMaine Instrument Flight · Augusta, MEBuilt 2023 · S/N 9533 N622TDHjma Leasing LLC · Pinecrest, FLBuilt 2020 · S/N 4909 N6231HCandace A Larned Enterprises Inc · Long Beach, CABuilt 1977 · S/N 28-7816238 N6232HParis Air Inc · Vero Beach, FLS/N 28-7816240 N6234CSchilling Aviation Services LLC · Salina, KSBuilt 1978 · S/N 28-7890349 N6235HAirworthyone LLC · Caledonia, MIBuilt 1977 · S/N 28-7890219 N6236JArcher N6236j LLC · Denver, COBuilt 1976 · S/N 28-7690377 N6237JHulett Michael · Saginaw, MOBuilt 1976 · S/N 28-7690378 N6239Arsenault Keith · West Brookfield, MABuilt 1984 · S/N 28-8590003 N623CAFast Flights LLC · Wilmington, DEBuilt 2019 · S/N 4744 N623CDVitalis Maynard · Medford, ORBuilt 2005 · S/N 1259 N623CPWiskow Aviation LLC · Buffalo, MNS/N 1946 N623DTaylor Steve B · Albuquerque, NMBuilt 2009 · S/N 4697416 N623DAHutson Neil · Issaquah, WABuilt 2008 · S/N 1901 N623DSFirst Western Capital Corp · Rllng Hls Est, CABuilt 2010 · S/N 40.1076 N623ESAerohp LLC · Cypress, TXBuilt 2018 · S/N 4708 N623FGDyeraviation LLC · College Station, TXBuilt 2017 · S/N 4697623 N623FTFlorida Institute Of Technology · Melbourne, FLBuilt 1977 · S/N 28-7816131 N623HAGt Holdings LLC · Nashville, TNBuilt 2026 · S/N 11293 N623JNBoard Of Trustees Of Western Michigan University · Battle Creek, MIS/N 4496499 N623MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2026 · S/N 40.1260 N623PTThomas Philip M · Monroe, LABuilt 2012 · S/N 4636543 N623SDTanner Aero LLC · Tulsa, OKBuilt 2007 · S/N 2833 N623SRFerx LLC · Myrtle Beach, SCBuilt 2007 · S/N 2461 N623THSaquatucket Adventures LLC · Wilton, CTBuilt 2007 · S/N 41763 N623VSJones Lloyd Val · Blanding, UTBuilt 2005 · S/N 1708 N623WMMclaughlin Mike I · Portola Valley, CABuilt 2002 · S/N 0208 N6240HLouisa Air LLC · Louisa, VAS/N 28-7890220 N6242CFlight School 101 LLC · Winter Haven, FLBuilt 1978 · S/N 28-7816399 N6247JInternational Air Services Inc Trustee · Carson City, NVS/N 28-7690380 N6248CFort Leavenworth Flying Club · Fort Leavenworth, KSS/N 28-7816629 N624ABGenelle Aviation LLC · Parsippany, NJBuilt 2025 · S/N 10966 N624AQHigh Flight Academy LLC · Allison Park, PABuilt 1984 · S/N 28-8416122 N624AVWestwind School Of Aeronautics Phoenix LLC DBA · Goodyear, AZBuilt 2025 · S/N 10887 N624CDProvincial Properties LLC · Johnson City, TNS/N 1119 N624CJJones Steven Clark · Flagler Beach, FLBuilt 2020 · S/N 2881427 N624CMJma Aviation LLC · Cincinnati, OHS/N 1249

Back to AD 2008-06-28 R1