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.

N722SCSteward Christopher B Trustee · Dedham, MABuilt 2006 · S/N 1776 N722SRLmsc LLC · Camden, DEBuilt 2006 · S/N 1952 N722STSky Ferry Aircraft Delivery LLC · Wilmington, DEBuilt 2005 · S/N 40.598 N722TCSchmitz William C · Charleston, SCBuilt 1978 · S/N 28-7990127 N722VPValiair Limited Co Trustee · Casper, WYBuilt 2006 · S/N 2300 N7232CVector Aviation LLC · Mentor, OHBuilt 1976 · S/N 28-7690061 N72383Niagarawings Aviation LLC · Niagara Falls, NYBuilt 1977 · S/N 28-7890141 N723AGShortt Aircraft Leasing LLC · Wilmington, DEBuilt 2004 · S/N 40.427 N723AJCavorite Aviation LLC · West Jordan, UTBuilt 2005 · S/N 2843613 N723APN816k LLC · Kalispell, MTS/N 4636093 N723CPWidener Jeanette C · Snohomish, WABuilt 2004 · S/N 1216 N723DAShelton Aviation II LLC · Apex, NCBuilt 2023 · S/N 9593 N723DGEyefly LLC · Hastings, NEBuilt 2023 · S/N 4636827 N723EBWeber Nicholas J · Pinehurst, NCBuilt 2004 · S/N 1387 N723GTMiracle On Techwood LLC · Ponte Vedra Beach, FLBuilt 2007 · S/N 2308 N723HPBlue Heron Aircraft & Yacht Sales LLC · Indialantic, FLBuilt 2001 · S/N 0130 N723KGcn Investments LLC · Hastings, NEBuilt 2008 · S/N 4697348 N723MGInternational Air Services Inc Trustee · Carson City, NVBuilt 2007 · S/N 40.832 N723PC43rd Aviation Flying Club Inc · Norfolk, CTFirst renewal noticeBuilt 1998 · S/N 2843194 N723PLN723pl LLC · Pensacola, FLBuilt 2025 · S/N 10914 N723SDCleveland Aviation LLC · Westlake, OHBuilt 2006 · S/N 1822 N723TMCreative Estates LLC · Greenwood Village, COBuilt 2008 · S/N 3012 N724AMeridian Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843790 N724ATH Squared Aviation LLC · Sheridan, WYBuilt 1984 · S/N 32R-8429027 N724CASouth Shore Flying Club Inc · South Weymouth, MABuilt 1999 · S/N 2843224 N724CDStrong Evan Edward · San Antonio, TXBuilt 2001 · S/N 0070 N724CMParker Air LLC · Mobile, ALBuilt 2005 · S/N 1557 N724DAThorondor Aero LLC · Asheville, NCBuilt 2023 · S/N 9596 N724DEAero Air LLC · Hillsboro, ORBuilt 2004 · S/N 1140 N724DWParagon Airplane Leasing Co · Fort Myers, FLBuilt 2023 · S/N 28020124 N724HAPriori Holdings Inc · Jacksonville, FLBuilt 2008 · S/N 4697375 N724JTGoldenhour Aviation LLC · Wilton, CTBuilt 2026 · S/N 11162 N724KBAdg Logistics LLC · Riverside, CABuilt 2013 · S/N 4692196 N724RStardust Aviation LLC · Farmingdale, NYBuilt 2003 · S/N 2843543 N724SRFlyme2 LLC · Leesburg, VABuilt 2006 · S/N 2167 N724TTAero Summit LLC · Los Angeles, CABuilt 2012 · S/N 2218 N7258CRegistered aircraftBuilt 1975 · S/N 28-7690063 N7259CN7259c LLC · Indianapolis, INBuilt 1975 · S/N 28-7690064 N725AAMoon Flying LLC · Centreville, VABuilt 2025 · S/N 10669 N725CDRussell Wade M Jr · Sandy Springs, GABuilt 2001 · S/N 0071 N725CPHolmberg Bryan J · Parkland, FLBuilt 2008 · S/N 3352 N725EAMaple8 Holdings LLC · Dallas, TXBuilt 2008 · S/N 411018 N725EBHickory Falls LLC · Naperville, ILBuilt 2016 · S/N 4333 N725EDMolden Erik · Newtown, PABuilt 2012 · S/N 4636555 N725LKDuluth Aviators LLC · Duluth, MNBuilt 2003 · S/N 0668 N725MA100ll First Class LLC · Santa Rosa Beach, FLBuilt 2023 · S/N 4636835 N725NDUniversity Of North Dakota · Grand Forks, NDBuilt 2023 · S/N 2881620 N725RABar Environmental Supply Inc · Brentwood, TNBuilt 1980 · S/N BB-725 N725SBSanda Aviation LLC · Nevada City, CAS/N 1363 N725SVTtc Aircraft Leasing Inc · Decatur, TXBuilt 1978 · S/N 441-0051

Back to AD 2008-06-28 R1