Registered aircraft · 36

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:2012-26-07') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-26-07') 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:2012-26-07')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-26-07')
  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:2012-26-07')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-26-07')
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 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 N234BUHeli-USA Corp · Houston, TXS/N 1210 N274CHWalker Kenneth E · Ford City, PABuilt 1989 · S/N 2306 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 N352VHElt Holdings LLC · Cottonwood, AZBuilt 1985 · S/N 1838 N4075SD&B Global Ventures LLC · Key West, FLBuilt 1997 · S/N 3043 N4AKAris Aviation Group LLC · Boulder City, NVS/N 2544 N57954Ns Air Leasing LLC · Wilmington, DEBuilt 1979 · S/N 1127 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 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 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 N927LBElt Holdings LLC · Cottonwood, AZBuilt 1990 · S/N 2347 N966FSTumbleweed Leasing Co Inc · West Jordan, UTBuilt 1989 · S/N 2301 N99676Alpine Air Alaska LLC · Girdwood, AKBuilt 1982 · S/N 1542

Back to AD 2012-26-07