Skip to content

Registered aircraft · 614

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:81-26-01-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:81-26-01-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:81-26-01-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:81-26-01-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:81-26-01-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:81-26-01-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.

N35002Md Helicopters LLC · Mesa, AZS/N 0360FF N35006Md Helicopters LLC · Mesa, AZS/N 0361FF N35011Md Helicopters LLC · Mesa, AZBuilt 2024 · S/N 0350FF N35017Md Helicopters LLC · Mesa, AZBuilt 2024 · S/N 0349FF N35019Usda Aphis Ws Atoc · Cedar City, UTBuilt 2024 · S/N 0348FF N3501DMd Helicopters LLC · Mesa, AZBuilt 2026 · S/N 0356FF N3501FMd Helicopters LLC · Mesa, AZS/N 0359FF N3501LMd Helicopters LLC · Mesa, AZS/N 0358FF N3501NMd Helicopters LLC · Mesa, AZBuilt 2024 · S/N 0339FF N3501QMd Helicopters LLC · Mesa, AZS/N 0338FF N3501TMd Helicopters LLC · Mesa, AZS/N 0354FF N3501VMd Helicopters LLC · Mesa, AZBuilt 2024 · S/N 0353FF N3501ZMd Helicopters LLC · Mesa, AZBuilt 2024 · S/N 0351FF N3502AMd Helicopters LLC · Mesa, AZBuilt 2024 · S/N 0347FF N3502PMccarty David M · Baker City, ORBuilt 2023 · S/N 0346FF N353AHBank Of Utah Trustee · Salt Lake City, UTBuilt 1981 · S/N 811079D N357MHAa Leasing Lp · Kilauea, HIBuilt 1982 · S/N 1171D N35KHBlackbell 22 LLC · Wilmington, DEBuilt 2024 · S/N 0355FF N361SHLima Whiskey LLC · Missoula, MTBuilt 1989 · S/N 0058FF N362MNHeli Ag LLC · Plantersville, TXBuilt 1979 · S/N 390462D N363CCBank Of Utah Trustee · Salt Lake City, UTBuilt 1977 · S/N 1070208D N363JSWilson Robert B · Superior, AZBuilt 1973 · S/N 930517S N365PRAerotrust Services Corp Trustee · Wilmington, DES/N 1180365D N367PDCity Of Atlanta · Atlanta, GABuilt 2023 · S/N 0344FF N369AVVista I Inc · Smithville, OHBuilt 1970 · S/N 110282-S N369DRatcliff Dustin · Saltville, VABuilt 1977 · S/N 1070209D N369DB110288s Inc Trustee · Wilmington, DES/N 110288-S N369DFPerry James · Monroe, WAS/N 820404S N369DRReynolds Darryl G · Wills Point, TXBuilt 1967 · S/N 67-16647 N369EDMonroe Helicopters LLC · Vestavia, ALBuilt 1978 · S/N 870167D N369EHApplebee Aviation Inc · Banks, ORBuilt 1980 · S/N 1200861D N369FCFerguson And Sons Construction LLC · Emmett, IDBuilt 1981 · S/N 610983D N369FFBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 0709FF N369FLVasilescu Paul · Hoboken, NJS/N 560819S N369GNBig Bird Leasing Inc · Saint Peter, MNS/N 140553S N369GSHellyer Aviation · Worland, WYBuilt 1973 · S/N 1230548S N369HAAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1976 · S/N 660821S N369HEN369he LLC · Wickenburg, AZBuilt 1969 · S/N 1090205E N369HSPurcell Ian · San Diego, CABuilt 1976 · S/N 850763S N369JHJack Harter Helicopters Inc · Lihue, HIBuilt 1985 · S/N 0145E N369JVAviation Advantage Inc · Tabor City, NCS/N 0334E N369KDDairy Air LLC · Scottsdale, AZBuilt 1983 · S/N 0037E N369KECbft LLC · Mobile, ALBuilt 1969 · S/N 991271 N369KVAgricultural Air Services LLC · Jupiter, FLBuilt 1980 · S/N 300659D N369LRCenterline Holdings Inc · Camden, DES/N 610991D N369MHAa Leasing Lp · Kilauea, HIBuilt 1978 · S/N 380287D N369MPAviation Advantage Inc · Tabor City, NCBuilt 1977 · S/N 670150D N369NKButler Aviation Investments LLC · Tonopah, AZBuilt 1972 · S/N 520385S N369PBHelicopter Aviation Services & Leasing Inc · Miami, FLBuilt 1978 · S/N 480305D N369PDCity Of Atlanta · Atlanta, GABuilt 2001 · S/N 0721FF

Back to AD 81-26-01 R1