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.

N959GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881473 N959MMBugle Equipment And Leasing LLC · Houston, TXBuilt 2003 · S/N 3257325 N959PMD W Lusk Contracting LLC · Snowflake, AZBuilt 2007 · S/N 41728 N959WATailwind Flyers LLC · Guilderland, NYBuilt 1982 · S/N 34-8233080 N959WTAgave I LLC · Seattle, WABuilt 2004 · S/N 1120 N95AGSale Reported · Montgomery, ALSale reportedBuilt 1990 · S/N 4622110 N95APWingnut Enterprises Inc · Sarasota, FLBuilt 1995 · S/N 32-46012 N95CMStambaugh Scot D · Gig Harbor, WABuilt 2009 · S/N 3435 N95DSale Reported · GuernseySale reportedBuilt 1998 · S/N 3449060 N95EERjt&E LLC · Spring, TXBuilt 2004 · S/N 42036 N95GTInternational Air Services Inc Trustee · Carson City, NVBuilt 2006 · S/N 1758 N95KWJames Bradley · Redwood City, CABuilt 2007 · S/N 4697301 N95LBTate James D · Christiansted, VIS/N LW-24 N95TRegistered aircraftBuilt 1987 · S/N 3213003 N95TSSkywest Leasing Inc · St George, UTBuilt 1997 · S/N 2843103 N95UXColumbiajs LLC · Houston, TXBuilt 2007 · S/N 41786 N9600UUniversity Of Oklahoma · Norman, OKBuilt 1978 · S/N 28-7816505 N9605CA O G Aircraft Services LLC · Aberdeen, NJBuilt 1978 · S/N 28-7816502 N9607CLmc Aviation LLC · Goleta, CABuilt 1978 · S/N 28-7890429 N960ACNaples Air Center Inc · Naples, FLBuilt 1990 · S/N 2841325 N960BGGokce Baran · Plantation, FLBuilt 2024 · S/N 10179 N960BPCavu Enterprises LLC · Atlanta, GABuilt 2004 · S/N 1110 N960CM960 Charlie Mike LLC · Santa Rosa, CABuilt 2001 · S/N 0041 N960GRomeo & Juliet Travel LLC · Danbury, CTBuilt 2002 · S/N 4697120 N960JAN215mt LLC · Port Orange, FLBuilt 2007 · S/N 2578 N960PDodson International Parts Inc · Rantoul, KSBuilt 2002 · S/N 0426 N960TMCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11662 N960WCStardust Aviation LLC · Farmingdale, NYBuilt 2000 · S/N 2843368 N961ABPiper Aircraft Inc · Vero Beach, FLS/N 28010089 N961CDSouthpoint Development Inc · Jacksonville, FLBuilt 2006 · S/N 1824 N961DACondair Flyers Inc · Latham, NYBuilt 1996 · S/N 2843034 N961GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881226 N961MAFlying Clubs Of America LLC · Englewood, COBuilt 2015 · S/N 4636669 N961TFAir Fleet Holdings LLC · Missoula, MTBuilt 2025 · S/N 2881961 N961TTLupia Raul H · Raleigh, NCBuilt 2004 · S/N 42054 N961WGChandler Air Service Inc · Chandler, AZBuilt 2000 · S/N 2843376 N9622CN9622c LLC · Clintondale, NYS/N 28-7816504 N9626CExecutive Flight Training & Services LLC · Sanford, NCBuilt 1978 · S/N 28-7816506 N9628KTriple Chin LLC · Bloomington, MNBuilt 1976 · S/N 28-7690266 N9629CFly Gateway Aviation Institute · New Castle, DEBuilt 1978 · S/N 28-7890430 N9629KN9629k LLC · Provo, UTBuilt 1976 · S/N 28-7690267 N962FMarshall Steven A · Blacksburg, VABuilt 1998 · S/N 3257067 N962GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881227 N962MAYalinie Medics LLC · Lexington, KYBuilt 2018 · S/N 4636735 N962MBDouble A Aviation Group LLC · Harrison, NYBuilt 2019 · S/N 4866 N962PJDove Wings LLC · Verona, NJBuilt 2025 · S/N 10872 N962PWHamilton Jesse L · Aledo, TXBuilt 2004 · S/N 1125 N962SRExploration Aviation LLC · San Antonio, TXBuilt 2007 · S/N 2669 N962WFDodson International Parts Inc · Rantoul, KSBuilt 1999 · S/N 4636203 N962WGChandler Air Services Inc · Chandler, AZBuilt 2000 · S/N 2843378

Back to AD 2008-06-28 R1