Registered aircraft · 1,015

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:82-09-51-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:82-09-51-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:82-09-51-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:82-09-51-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:82-09-51-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:82-09-51-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.

N633WMCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 5951 N640GRDodson International Parts Inc · Rantoul, KSS/N 5093 N648CR7107 Associates LLC · Wilmington, DEBuilt 2005 · S/N 5633 N648SGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 5720 N64JSCelebration Tv America Inc · Houston, TXBuilt 1992 · S/N 5119 N64LELuxury Jet Acquisitions Inc · Newville, ALBuilt 1988 · S/N 5031 N650ADAircraft Trust & Financing Corp Trustee · Wilmington, DEBuilt 2019 · S/N 6135 N650BSBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 6078 N650CFTvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2019 · S/N 6136 N650DWGbhp Associates LLC · Saratoga Springs, NYBuilt 2024 · S/N 6208 N650ELBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 6138 N650FBSierra Nevada Company LLC · Sparks, NVBuilt 2025 · S/N 6226 N650FNRegistered aircraftN-number assigned (import), not yet registeredS/N 6241 N650GEFlying High Leasing LLC · Atlanta, GABuilt 2019 · S/N 6132 N650GKGekabi Aviation LLC · The Woodlands, TXBuilt 2016 · S/N 6065 N650GPOcean Acquisition 3 LLC · Denver, COBuilt 2018 · S/N 6124 N650HJLambro Aircraft Management LLC · Hillsboro Beach, FLBuilt 2006 · S/N 5653 N650HNTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2020 · S/N 6160 N650JRRegistered aircraftBuilt 2016 · S/N 6081 N650LCAgco Corp · Duluth, GABuilt 2017 · S/N 6098 N650LERegistered aircraftN-number assigned (import), not yet registeredS/N 6240 N650RSSchumacher Oil LLC · Whitefish, MTS/N 7779 N650SKPnc Bank Na · Boise, IDBuilt 2017 · S/N 6096 N651AMAirmed International LLC · Birmingham, ALBuilt 2011 · S/N 5883 N651JDA S K Equipment Leasing LLC · Cumming, GABuilt 2012 · S/N 5921 N651LSWestwind Air Holdings Inc · Wilmington, DEBuilt 1999 · S/N 5413 N652AMAirmed International LLC · Birmingham, ALBuilt 2008 · S/N 5756 N654CMPacific States Industries Inc · Morgan Hill, CABuilt 1987 · S/N 5009 N657GFChallenger 601 - 3045 Inc · Wilmington, DES/N 3045 N659BRLogos Aviation Inc · Fort Lauderdale, FLBuilt 2001 · S/N 7509 N65PXSpx Enterprises LLC · Charlotte, NCBuilt 2009 · S/N 5804 N669LAFlash Enterprise LLC · Helena, MTBuilt 1989 · S/N 5050 N675BRLogos Aviation Inc · Fort Lauderdale, FLBuilt 2002 · S/N 7635 N679SASkywest Airlines Inc · St George, UTS/N 7652 N679WDanforth LLC · Columbus, OHBuilt 2020 · S/N 6158 N67RSLabell Aviation LLC · Spring Hill, FLBuilt 1994 · S/N 5149 N681HCIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 2001 · S/N 5518 N683UFUnifirst Corp · Manchester, NHBuilt 2007 · S/N 5734 N685BRBank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 7712 N686BRBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 7715 N689MVBypass Tsa LLC · Chesterfield, MOBuilt 2005 · S/N 5631 N689SCRegistered aircraftBuilt 2007 · S/N 5716 N68ABRockwell Automation Inc · Milwaukee, WIBuilt 2024 · S/N 6202 N691CCWilmington Trust Co Trustee · Wilmington, DEBuilt 1993 · S/N 5126 N693BRSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7761 N696HSMocha LLC · Tucson, AZBuilt 2009 · S/N 5819 N698GGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 6120 N698RSNo Bull Air LLC · Chandler, AZBuilt 2000 · S/N 5460 N699BRSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7801 N699STOrange Equipment LLC · Miami Beach, FLBuilt 2006 · S/N 5743

Back to AD 82-09-51 R1