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.

N166SRAvepartners LLC · Hope Mills, NCBuilt 2007 · S/N 1764 N166TRBourn Bryan · Jordan, MNBuilt 2002 · S/N 0264 N166TTTruex Paul F · Sarasota, FLBuilt 2010 · S/N 411156 N1675HIcarus Flying Academy LLC · Farmingdale, NYBuilt 1977 · S/N 28-7716040 N1676HClass Bee Inc · Pensacola, FLS/N 28-7716041 N1678Dgs Aviation LLC · Georgetown, DEBuilt 2026 · S/N 11447 N1678HBrown Gregory B · New London, CTBuilt 1977 · S/N 28-7790330 N1679HLake Elmo Aero LLC · Lake Elmo, MNS/N 28-7790331 N167CAGoody For US Aviation LLC · Miami, FLBuilt 2026 · S/N 11191 N167CDSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 1073 N167CTBlomgren Paul · Yorba Linda, CABuilt 2008 · S/N 2959 N167SPEnnis James D Jr Trustee · Dalton, NHBuilt 2009 · S/N 3580 N167WPCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11541 N1681TDrc Air LLC · Wilmington, DEBuilt 2014 · S/N 4081 N1688HAbsolute Imaging Inc · Corona, CABuilt 1977 · S/N 28-7790332 N1689HIxi LLC · West Bloomfield, MIS/N 28-7790333 N168BLWingsleasing LLC · Wichita, KSBuilt 2024 · S/N 2881768 N168CDCirrusly LLC · Kalispell, MTBuilt 2000 · S/N 1079 N168CMI'Ll Fly Away LLC · Goshen, INBuilt 2020 · S/N 2588 N168DJWarren Patrick S · Columbus, OHBuilt 2023 · S/N 9347 N168FReading Aero Club Inc · Reading, PABuilt 1999 · S/N 2843264 N168GFC2c LLC · Christiansted, VIS/N 4636189 N168LHFarmingdale State College · Farmingdale, NYBuilt 2020 · S/N 2881374 N168MCRegistration Pending · Wayne, PARegistration pendingBuilt 2023 · S/N 9483 N168MPValiair Ltd Co Trustee · Casper, WYBuilt 2007 · S/N 2692 N168RVAkn Enterprises LLC · Springfield, MOBuilt 2006 · S/N 4697252 N168SRWisconsin Aviation-Four Lakes Inc · Madison, WIBuilt 2006 · S/N 1747 N1697HOwen Richard L · Milton, DES/N 28-7716046 N1699HFitzpatrick Yuma T · Blakely Island, WABuilt 1977 · S/N 28-7790335 N169AGSkywest Leasing Inc · St George, UTBuilt 2024 · S/N 2881810 N169CDGroseth Cyler D Sr · Surprise, AZFirst renewal noticeS/N 1077 N169DWA&P Properties LLC · Manns Choice, PABuilt 2005 · S/N 1523 N169EBMutyala Susheel V · Bellevue, WABuilt 2001 · S/N 3449230 N169HTAerie Leisure Inc · Phoenix, AZBuilt 2005 · S/N 41054 N169LCValiair Lc Trustee · Casper, WYBuilt 2025 · S/N 10856 N169LHFarmingdale State College · Farmingdale, NYBuilt 2020 · S/N 2881375 N169MFCommodore Aviation LLC · Palm Beach, FLBuilt 1981 · S/N 441-0221 N169PJBernard Douglas A · New Iberia, LABuilt 2005 · S/N 41065 N169SRHallgren Aviation LLC · Lubbock, TXBuilt 2007 · S/N 1767 N169SWFluxtronic · Nashville, TNBuilt 2009 · S/N 411136 N16BSN16bs LLC · Austin, TXBuilt 2026 · S/N 11372 N16BTN16bt Leasing LLC · Austin, TXBuilt 2024 · S/N 9928 N16FJRaven Air LLC · Hotchkiss, COBuilt 1978 · S/N 441-0067 N16HBChevalier Greg D · Horton, MIBuilt 2003 · S/N 0757 N16HLPlane Fun Inc Tr Trustee · Snellville, GABuilt 1968 · S/N 28R-30675 N16KELre Aviation LLC · Lakeview, OHBuilt 2011 · S/N 2091 N16NWCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1978 · S/N 441-0045 N16RJParagon Airplane Leasing Co · Fort Myers, FLBuilt 2024 · S/N 28020193 N16TJJean-Louis Lesly G · Loxahatchee, FLBuilt 2004 · S/N 3232034 N16VABs LLC · North Vernon, INBuilt 2003 · S/N 42008

Back to AD 2008-06-28 R1