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.

N2191EBel Air Aviation LLC · Chesaning, MIFirst renewal noticeBuilt 1978 · S/N 28-7990179 N2192LSiller Brothers Incorporated · Yuba City, CABuilt 1976 · S/N LW-192 N2193VApm Leasing LLC · Casper, WYBuilt 1979 · S/N 44-7995266 N2194KAviation Training LLC · Wilmington, DEBuilt 1978 · S/N 44-7995203 N2195EZameroski Daniel C · Mckean, PABuilt 1978 · S/N 28-7990182 N2196VFixed Wing Holding Co Inc · Pembroke Pines, FLBuilt 1979 · S/N 44-7995267 N21985N21985 LLC · Deltona, FLBuilt 1978 · S/N 28-7990066 N219AMeridian Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843788 N219BCArcovia Air LLC · Loganville, GABuilt 2006 · S/N 4697284 N219CDCd Flyers LLC · Port Orange, FLBuilt 2001 · S/N 1124 N219CPHam Steven W · Keswick, VABuilt 2006 · S/N 1750 N219DL3 Wolfpack Sigma LLC · Overland Park, KSBuilt 1999 · S/N 4636209 N219DGCtrl Electrical LLC · Lexington, NCBuilt 1999 · S/N 3246134 N219DSJojo & Dino Ltd · Frederick, MDBuilt 2002 · S/N 40.219 N219ELAssadourian Noubar · Glendale, CABuilt 2007 · S/N 1781 N219EPEpic Aviation Inc · New Smyrna, FLBuilt 2019 · S/N 4496458 N219MRMp Worldwide Holdings LLC · West Palm Beach, FLBuilt 2007 · S/N 1782 N219PMPmm Aviation Inc Trustee · Wilmington, DEBuilt 2007 · S/N 2756 N21AGGronemeyer Jens · Deland, FLS/N 4636106 N21ASBoa Properties LLC · Valdosta, GABuilt 1968 · S/N 28R-30862 N21CBTailworks LLC · Seabrook, TXBuilt 2018 · S/N 4683 N21DCDlc Aviation LLC · Lattingtown, NYBuilt 2018 · S/N 4632 N21DELocke-Lane Aviation LLC · Statesville, NCBuilt 1976 · S/N BB-117 N21EDHutcheson Jon · Greencastle, INS/N 28-7716031 N21EFElite Flight Experience LLC · Princeton, NJBuilt 2020 · S/N 2562 N21EPC&J Aviation LLC · Orono, MNBuilt 2012 · S/N 4697500 N21EQBernoulli Otto Wright & Parkinsons Contraption LLC · Mansfield, CTBuilt 2005 · S/N 1457 N21FGCalifornia Department Of Fish And Game · Sacramento, CABuilt 1981 · S/N BB-839 N21FPJet There LLC · Cedar Rapids, IABuilt 2024 · S/N 9826 N21GTDesign Leasing Group LLC · Pittsburgh, PABuilt 2017 · S/N 4450 N21KTTatkowski Dorota · Mount Prospect, ILBuilt 2024 · S/N 10245 N21LZKrishna Group Inc · Oklahoma City, OKS/N 0267 N21MGVortex Aviation LLC · Lafayette, LABuilt 2003 · S/N 42034 N21SUSouthern Utah University · Cedar City, UTBuilt 2017 · S/N 2365 N21TENational Test Pilot School · Mojave, CABuilt 2004 · S/N 0964 N21TRCareer Aviation Company Inc · Wilmington, DEBuilt 2023 · S/N 28020116 N21UKInternational Air Services Inc Trustee · Carson City, NVS/N 2311 N21WEMingst Barry Chris · Bellevue, WABuilt 2009 · S/N 3370 N21XJMcgrew Eric W · Anacortes, WABuilt 2009 · S/N 2019 N21YYShep Air Inc · Cedar Rapids, IABuilt 2005 · S/N 1664 N21ZECampolo Michael J · Camarillo, CABuilt 2003 · S/N 1372 N220Atlantic Coast Aviation Inc · Dover, DEBuilt 2002 · S/N 0177 N2202AArtisan Aviation Inc · Rochester, NYBuilt 1978 · S/N 28-7916102 N2202WMiloud Chadd K · Fort Worth, TXBuilt 1979 · S/N 28-7916332 N2202ZHazlewood Norman R · Wichita, KSBuilt 1981 · S/N 28-8116278 N2203ASs Three LLC · North Platte, NEBuilt 1978 · S/N 28-7990111 N2203DWhytes Inc · Coconut Creek, FLBuilt 1978 · S/N 28-7916148 N2203FElk Flyers Inc · Saint Marys, PABuilt 1978 · S/N 28-7990191 N2203MLane Aviation Academy · Eugene, ORBuilt 1977 · S/N 28-7816258 N2203TGateway Flight Training LLC · Saint Louis, MOBuilt 1979 · S/N 28-7916300

Back to AD 2008-06-28 R1