Skip to content

Registered aircraft · 623

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

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 N315AEAir Evac Ems Inc · O Fallon, MOBuilt 1980 · S/N 45482 N315MHCane Helicopter Services LLC · Franklin, LABuilt 1981 · S/N 45692 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 N3173HAlabama Law Enforcement Agency · Montgomery, ALBuilt 1982 · S/N 45714 N3176LRiggs Bobby W · Lake Mary, FLBuilt 1983 · S/N 45648 N3180LGm Leasing Co LLC · Broussard, LABuilt 1983 · S/N 51055 N3188PMarks Aviation Group LLC · Lafayette, LABuilt 1983 · S/N 45778 N318AEAir Evac Ems Inc · O Fallon, MOBuilt 1985 · S/N 51160 N318RLOcean Air Helicopters Inc · Port Orford, ORBuilt 2005 · S/N 52318 N3190PVeturis David · Lake Forest, CABuilt 1983 · S/N 45779 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 N336AEAir Evac Ems Inc · O Fallon, MOBuilt 2012 · S/N 52436 N337AEAir Evac Ems Inc · O Fallon, MOBuilt 1980 · S/N 45383 N338AEGm Leasing Co LLC · Broussard, LABuilt 1994 · S/N 52087 N33PPUnited States Department Of Interior · Boise, IDBuilt 1983 · S/N 51051 N33RSFlying H Limited LLC · Mesa, AZBuilt 1992 · S/N 51568 N343ALBtak LLC · New Baden, ILBuilt 1990 · S/N 51372 N346BFState Of Washington · Olympia, WAFirst renewal noticeBuilt 2007 · S/N 52346 N347MJam Zoom Yayos LLC · Manheim, PABuilt 1981 · S/N EA-253 N34RMCrm Holdings LLC · Missoula, MTBuilt 2006 · S/N 52333 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 N3501NMd Helicopters LLC · Mesa, AZBuilt 2024 · S/N 0339FF N3501VMd Helicopters LLC · Mesa, AZBuilt 2024 · S/N 0353FF N3501ZMd Helicopters LLC · Mesa, AZBuilt 2024 · S/N 0351FF N3502PMccarty David M · Baker City, ORBuilt 2023 · S/N 0346FF N351RLOas2 LLC · Orlando, FLBuilt 1991 · S/N 51431 N352TCHillsborough County Board Of County Commissioners · Tampa, FLS/N 52390 N355AEAir Evac Ems Inc · O Fallon, MOBuilt 2011 · S/N 52425 N357SPLouisiana Department Of Public Safety · Baton Rouge, LABuilt 1996 · S/N 52161

Back to AD 86-20-13