Registered aircraft · 2,382

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:2013-22-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2013-22-21') 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:2013-22-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2013-22-21')
  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:2013-22-21')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2013-22-21')
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.

N859MPPhoenix Coal Holdings LLC · Lexington, KYBuilt 2024 · S/N 56388 N85AWScotts Helicopter Service · Le Sueur, MNS/N 45261 N85CAChurchill Scott · Le Sueur, MNBuilt 1967 · S/N 101 N85RBScott John D · Lyndon, KSBuilt 1972 · S/N 831 N860Helicopter 2019 LLC · Chesterfield, MOBuilt 2022 · S/N 56323 N8603Rtl Aviation LLC · Giddings, TXBuilt 2019 · S/N 54844 N860DPNewton Property Leasing LLC · Greene, IABuilt 1975 · S/N 1716 N861MTLindsey Aviation Services · Haslet, TXBuilt 2006 · S/N 53693 N862MChorman Spraying LLC · Milton, DEBuilt 1997 · S/N 4473 N862YBGm Leasing Company LLC · Broussard, LABuilt 2019 · S/N 54837 N864HHillcrest Aircraft Co Inc · Lewiston, IDBuilt 1996 · S/N 53017 N866ELEly Ag Services LLC · Sallisaw, OKBuilt 1980 · S/N 3036 N866HLake Superior Helicopters LLC · Duluth, MNBuilt 1981 · S/N 3291 N866MMiddlesex County Mosquito Extermination Commission · Edison, NJBuilt 1998 · S/N 4476 N867CHNorthview Christian Church · Dothan, ALBuilt 1974 · S/N 1371 N868HWeyerhaeuser Nr Co · Seattle, WABuilt 1989 · S/N 51318 N868JBHorizon Helicopter LLC · Pembroke, NHBuilt 2000 · S/N 4534 N868KKCoastal Helicopters Inc · Panama City, FLBuilt 1976 · S/N 2031 N86DXTopside Aviation Inc · Brasstown, NCBuilt 1986 · S/N 3960 N86FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLBuilt 1976 · S/N 2104 N86NCb Couch Inc · Walcott, ARBuilt 1980 · S/N 3204 N86PHProvine Helicopter Service Inc · Greenwood, MSBuilt 1991 · S/N 51436 N870AEAir Evac Ems Inc · O Fallon, MOBuilt 2025 · S/N 56443 N871AEAir Evac Ems Inc · O Fallon, MOBuilt 2025 · S/N 56451 N871STPennsylvania State Police · Hershey, PABuilt 2013 · S/N 54451 N872STPennsylvania State Police · Hershey, PABuilt 2014 · S/N 54475 N873STPennsylvania State Police · Hershey, PABuilt 2014 · S/N 54500 N874MAnastasia Mosquito Control District · Saint Augustine, FLBuilt 2003 · S/N 4569 N874STPennsylvania State Police · Hershey, PABuilt 2014 · S/N 54494 N875STPennsylvania State Police · Hershey, PABuilt 2013 · S/N 54449 N876ACIntersouth Inc · Santo DomingoS/N 53492 N876GJBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 53820 N876STPennsylvania State Police · Hershey, PABuilt 2013 · S/N 54450 N877STArizona Helicopter Services LLC · Prescott, AZBuilt 1998 · S/N 53316 N87APGm Leasing Company LLC · Broussard, LABuilt 2004 · S/N 53624 N87JRRoche Gerald Aloysius · KildareBuilt 2004 · S/N 52291 N87WPMarks Lloyd L · Lafayette, LABuilt 1992 · S/N 52011 N885MCPolk County · Bartow, FLBuilt 2005 · S/N 4592 N886AEAir Evac Ems Inc · O Fallon, MOBuilt 2016 · S/N 52486 N887AETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2016 · S/N 52487 N887EHVertical Vegetation Management LLC · Darlington, INBuilt 1975 · S/N 1774 N888DJD M Farms Of Rose Hill LLC · Wallace, NCBuilt 2000 · S/N 53408 N888PZCoastal Air LLC · Helena, MTBuilt 2008 · S/N 53898 N889MGM G 2010 LLC · Saint Petersburg, FLBuilt 2010 · S/N 54020 N889MTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 54630 N88AEAir Evac Ems Inc · O Fallon, MOBuilt 2014 · S/N 52457 N88BDSouthern Illinois Helicopters LLC · Marion, ILBuilt 2004 · S/N 52285 N88EGAviation Echo LLC · Monson, MABuilt 2025 · S/N 56427 N88HCTri-Rotor Spray & Chemical · Ulysses, KSBuilt 1975 · S/N 1576 N88PPGo Heli LLC · San Diego, CABuilt 1980 · S/N 3215

Back to AD 2013-22-21