Skip to content

Registered aircraft · 562

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-13-12-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-13-12-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-13-12-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-13-12-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-13-12-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-13-12-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.

N277AEAir Evac Ems Inc · O Fallon, MOBuilt 1990 · S/N 51421 N277TBSierra Flite LLC · Camden, DES/N 51189 N279THT & T Capital Inc · Bangor, MEBuilt 1986 · S/N 51176 N27HXHelicopter Express LLC · Chamblee, GABuilt 1996 · S/N 53012 N27MHelicopters Inc · Wilmington, DEBuilt 1993 · S/N 52045 N27TKAir Resources Helicopters Inc · Salt Lake City, UTBuilt 1985 · S/N 51138 N281AEAir Evac Ems Inc · O Fallon, MOBuilt 1991 · S/N 51451 N282AEOas2 LLC · Orlando, FLBuilt 1991 · S/N 51452 N283BHJohnson Flying Service LLC · Exira, IABuilt 1991 · S/N 51510 N285AEAir Evac Ems Inc · O Fallon, MOBuilt 1992 · S/N 51550 N285RRBentley Drive LLC · Anchorage, AKBuilt 1982 · S/N 51041 N288AEAir Evac Ems Inc · O Fallon, MOBuilt 1989 · S/N 51327 N288WSWorld Trade Enterprises LLC · Lucas, TXBuilt 1988 · S/N 2087 N28LZLindemann Thomas · Gustine, CABuilt 1981 · S/N U20606531 N28NAPremier Rotors LLC · Saint Martinville, LABuilt 1990 · S/N 51387 N290AEAir Evac Ems Inc · O Fallon, MOBuilt 1986 · S/N 51192 N293AEAir Evac Ems Inc · O Fallon, MOBuilt 1992 · S/N 51476 N295AEAir Evac Ems Inc · O Fallon, MOBuilt 1991 · S/N 51455 N295SJPremier Rotors LLC · Saint Martinville, LABuilt 1994 · S/N 52059 N296CCClayton County Police Department · Jonesboro, GABuilt 1990 · S/N 51389 N298JWHeliservice LLC · Wilmington, DEBuilt 2023 · S/N 0342FF N299AEAir Evac Ems Inc · O Fallon, MOBuilt 1981 · S/N 45621 N29AEAir Evac Ems Inc · O Fallon, MOBuilt 1986 · S/N 51191 N29WWPremier Rotors LLC · Saint Martinville, LABuilt 1995 · S/N 52157 N2NJNew Jersey State Police · Ewing, NJBuilt 1985 · S/N 51-122 N301JAJaars Inc · Waxhaw, NCBuilt 2006 · S/N 52341 N304MHBank Of Utah Trustee · Salt Lake City, UTBuilt 1983 · S/N 51047 N306MHOlympic Jet Inc · Olympia, WABuilt 1991 · S/N 51449 N307APMg Holdings LLC · Alpine, WYBuilt 2020 · S/N 0323FF N3094GScotts Helicopter Services Inc · Le Sueur, MNBuilt 1965 · S/N 3361 N31079Top Flight Aviation Of Mississippi LLC · Picayune, MSBuilt 1991 · S/N 51526 N3107WWeyerhaeuser Nr Co · Seattle, WABuilt 1991 · S/N 51512 N311MHMaritime Helicopters Inc · Homer, AKBuilt 1996 · S/N 52055 N312NLYellowstone Wr Ranch LLC · Dillon, MTBuilt 1990 · S/N 51409 N313DHRogers Helicopters Inc · Fresno, CABuilt 1981 · S/N 45630 N313HPMshr Helicopter Services LLC · Chehalis, WABuilt 1990 · S/N 51341 N314AEAir Evac Ems Inc · O Fallon, MOBuilt 1999 · S/N 52222 N314MHBlade Leasing LLC · Homer, AKBuilt 1995 · S/N 52119 N315WCAnjum Mohammad A · Melrose Park, ILBuilt 1991 · S/N 51465 N316MHMaritime Helicopters Inc · Homer, AKBuilt 2006 · S/N 52323 N317Magic Carpet Aviation LLC · San Antonio, TXBuilt 1993 · S/N 52014 N3180LGm Leasing Co LLC · Broussard, LABuilt 1983 · S/N 51055 N318AEAir Evac Ems Inc · O Fallon, MOBuilt 1985 · S/N 51160 N318RLOcean Air Helicopters Inc · Port Orford, ORBuilt 2005 · S/N 52318 N321AHBektor III LLC · Kalispell, MTBuilt 1984 · S/N 51100 N325AEAir Evac Ems Inc · O Fallon, MOBuilt 1993 · S/N 52009 N327AEAir Evac Ems Inc · O Fallon, MOBuilt 1990 · S/N 51365 N3324FSummit Sales & Leasing Inc · Salem, VABuilt 1964 · S/N 1735 N333EROrlando Aircraft Sales LLC · Orlando, FLBuilt 1979 · S/N 45203 N334AEAir Evac Ems Inc · O Fallon, MOBuilt 1989 · S/N 51326

Back to AD 81-13-12 R1