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.

N1632HM & B Aero LLC · York, PABuilt 1977 · S/N 28-7790319 N1636JBrc Holdings LLC · La Follette, TNBuilt 2017 · S/N 4541 N1636ZConstantine Paul John Jr · Anderson, SCBuilt 2022 · S/N 8590 N1637HGross Leslie W · Perry, MES/N 28-7716030 N1638HKaczmarek James J Jr · Parksley, VABuilt 1977 · S/N 28-7716032 N163AVPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010061 N163CDRadioflyer Aviation LLC · Lathrup Village, MIBuilt 2000 · S/N 1067 N163DBDehghani Mohammad · Rolla, MOBuilt 2001 · S/N 3257210 N163JTLifetime Investment Solutions LLC · Hahira, GABuilt 2005 · S/N 3232042 N163LHFarmingdale State College · Farmingdale, NYBuilt 2010 · S/N 2842362 N163RWTactical Air Support Inc · Reno, NVBuilt 2012 · S/N 2160 N163STD&E Aircraft LLC · Newark, OHBuilt 2010 · S/N 4692143 N1640HArcher 1640h LLC · Oscoda, MIS/N 28-7790321 N1646H3k Aviation LLC · Iron Station, NCS/N 28-7716033 N1648HWcc Eco LLC · Arvada, COS/N 28-7790322 N164AVPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010060 N164BBPorter Patrick J · Greensboro, NCBuilt 2004 · S/N 1128 N164CA24-3227 Inc Trustee · Wilmington, DES/N 11674 N164CDStovall Ryan T · Alpharetta, GABuilt 2000 · S/N 1069 N164DPAviation Capital Management LLC · San Jose, CABuilt 1979 · S/N 28-8016190 N164ERSilver Express Co DBA · Miami, FLBuilt 1989 · S/N 2841180 N164GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881457 N164JAgster Robert J · Fstrvl Trvose, PABuilt 1980 · S/N 32R-8029071 N164LHPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010063 N164SWNew England Aviation LLC · Plainville, CTBuilt 1975 · S/N 28-7690077 N1652NAllison Christopher · Cartersville, GABuilt 1999 · S/N 3257119 N165ASVl Aviation LLC · Saint Petersburg, FLBuilt 2006 · S/N 40.702 N165AVPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010059 N165CDGray Andrew Trustee · San Diego, CABuilt 2000 · S/N 1070 N165FDEck Management Company LLC · Kingman, KSBuilt 2025 · S/N 10565 N165FTParis Air Inc · Vero Beach, FLBuilt 1982 · S/N 28-8216195 N165JYSt Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1977 · S/N 28-7890225 N165PPiper Aircraft Inc · Vero Beach, FLS/N 28020290 N165PSPhindogair LLC · Lubbock, TXBuilt 2005 · S/N 40.523 N165SRN165sr LLC · Waterford, VABuilt 2006 · S/N 1941 N1660HAtd Pilot Training LLC · Kansas City, MOS/N 28-7716037 N1661HRed Tail Scholarship Foundation · Tuskegee, ALS/N 28-7790325 N1663COlson Aviation LLC · Chandler, AZBuilt 2003 · S/N 0585 N1665CTaylorsville Lake Marina Inc · Simpsonville, KYBuilt 2003 · S/N 0587 N1668Paragon Airplane Leasing Co · Fort Myers, FLBuilt 2024 · S/N 28020178 N166ABSafford Aviation Service Inc · Coolidge, AZBuilt 1981 · S/N 34-8133134 N166DSJagar Holdings LLC · Fort Worth, TXS/N 42070 N166GAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 2004 · S/N 40.369 N166JPBaby Bird Aviation LLC · Sarasota, FLBuilt 2005 · S/N 40.502 N166LHFarmingdale State College · Farmingdale, NYBuilt 2020 · S/N 2881373 N166MABryant Kristy D · Mckinney, TXBuilt 2009 · S/N 4692120 N166MDDoan Aviation LLC · New Hope, PABuilt 2024 · S/N 10260 N166PGFlyers Aloft LLC · Winter Park, FLBuilt 2008 · S/N 1948 N166RAviate Palm Beach LLC · Lantana, FLBuilt 2024 · S/N 9995 N166RTTalgrad Aviation LLC · Cumming, GABuilt 2007 · S/N 2687

Back to AD 2008-06-28 R1