Registered aircraft · 59

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

N111LNC Lou Leasing LLC · Mankato, MNBuilt 1984 · S/N 1602 N113JPJuliette Papa Leasing LLC · Kalispell, MTBuilt 1989 · S/N 2265 N113PHCherokee Helicopter Service LLC · Ford City, PABuilt 1980 · S/N 1298 N114MXAir Resources Helicopters Inc · Salt Lake City, UTBuilt 1984 · S/N 1747 N119TVU S Helicopters Inc · Marshville, NCBuilt 1988 · S/N 2122 N129TVUS Helicopters Inc · Marshville, NCBuilt 1996 · S/N 2897 N132TVU S Helicopters Inc · Marshville, NCBuilt 1982 · S/N 1636 N151ADAtlantic Coast Maintenance · Palm Coast, FLS/N 1173 N212CMAerospace Trust Management LLC Trustee · Wilmington, DES/N 2232 N214STBank Of Utah Trustee · Salt Lake City, UTS/N 2141 N234BUHeli-USA Corp · Houston, TXS/N 1210 N274CHWalker Kenneth E · Ford City, PABuilt 1989 · S/N 2306 N275BPCity Of Burbank · Burbank, CAS/N 1930 N27WAWings Air Helicopters LLC · West Harrison, NYBuilt 1994 · S/N 2792 N288WSWorld Trade Enterprises LLC · Lucas, TXBuilt 1988 · S/N 2087 N312BPatriot Aviation Inc · Greenville, DES/N 2243 N345HEAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1980 · S/N 1357 N350BAEuro Tec Vertical Flight Solutions LLC · Eudora, KSS/N 2788 N350MALabutte Air Inc · Flint, MIBuilt 1986 · S/N 1882 N350NTNorth Texas Helicopters Inc · Newark, TXBuilt 1982 · S/N 1512 N350UKInternational Air Services Inc Owner Trustee · Carson City, NVBuilt 1980 · S/N 1244 N352VHElt Holdings LLC · Cottonwood, AZBuilt 1985 · S/N 1838 N3604TRotorcraft Support Inc · Fillmore, CABuilt 1979 · S/N 1158 N36TVUS Helicopters Inc · Marshville, NCS/N 1858 N394NSNorthstar Trekking · Juneau, AKBuilt 1979 · S/N 1066 N4075SD&B Global Ventures LLC · Key West, FLBuilt 1997 · S/N 3043 N48BGazelle LLC · Missoula, MTS/N 1481 N4AKAris Aviation Group LLC · Boulder City, NVS/N 2544 N57954Ns Air Leasing LLC · Wilmington, DEBuilt 1979 · S/N 1127 N5805TStefenelli Aviation N-Tr Inc Trustee · AtterseeS/N 1836 N596MSNs Air Leasing LLC · Wilmington, DEBuilt 1988 · S/N 1884 N596WAFleet Unlimited Inc · Pasadena, CABuilt 1990 · S/N 2329 N603CMSoutheast Helicopters LLC · Miami, FLBuilt 1991 · S/N 2491 N6080RTemsco Helicopters Inc · Ketchikan, AKBuilt 1992 · S/N 2685 N6094UTemsco Helicopters Inc · Ketchikan, AKBuilt 1994 · S/N 2751 N611TCAircraft Trustee Services Inc Trustee · Dover, DEBuilt 1988 · S/N 2123 N613CMEurotec Vertical Flight Solutions LLC · Eudora, KSS/N 1632 N614SDEurotec Vertical Flight Solutions LLC · Eudora, KSS/N 1534 N617TVUS Helicopters Inc · Marshville, NCS/N 1725 N619LHYukon Helicopters Inc · Bethel, AKBuilt 1980 · S/N 1263 N61HLTiny Bubbles Aviation Inc · Pacoima, CAS/N 2298 N61RKDylans Rv Center LLC · Sewell, NJBuilt 1998 · S/N 3145 N63CBBmf Heli LLC · Ogden, UTBuilt 1993 · S/N 2694 N669TFRidgeline Aviation Inc · Cordova, AKBuilt 1982 · S/N 1484 N744HDU S Helicopters Inc · Marshville, NCBuilt 1981 · S/N 1449 N792LFGulf State Aviation LLC · Tomball, TXBuilt 1978 · S/N 1035 N79FXSouthern Helicopters Inc · Sunshine, LABuilt 1979 · S/N 1204 N818HDUS Helicopters Inc · Marshville, NCBuilt 1990 · S/N 2376 N821SPAviation Concepts America LLC · Daytona Beach, FLBuilt 1988 · S/N 2106 N827SDEurotec Vertical Flight Solutions LLC · Eudora, KSS/N 1452

Back to AD 2026-12-09