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.

N402TDAir Metro Helicopters Inc · New City, NYBuilt 1990 · S/N 51383 N4032YBank Of Utah Trustee · Salt Lake City, UTBuilt 1981 · S/N 5180 N404AEAir Evac Ems Inc · O Fallon, MOBuilt 2011 · S/N 52434 N404MPIndustrial Helicopters LLC · Lafayette, LABuilt 1994 · S/N 52083 N405LPGm Leasing Co LLC · Broussard, LABuilt 1994 · S/N 52085 N405RLGlobal Aviation Florida LLC · Pompano Beach, FLBuilt 1990 · S/N 51405 N4068GGulf Coast Helicopters Inc · Pearland, TXBuilt 1968 · S/N 229 N406KKKehler Kelly · Saint Xavier, MTBuilt 2004 · S/N 52283 N406MPGm Leasing Co LLC · Broussard, LABuilt 1994 · S/N 52086 N406WHHeli-Works Flight Services LLC · Deer Lodge, MTBuilt 1991 · S/N 51537 N407AEAir Evac Ems Inc · O Fallon, MOBuilt 2009 · S/N 52409 N407CCCounty Of Contra Costa · Martinez, CABuilt 1997 · S/N 53090 N407CHClassic Medical Inc · North Salt Lake, UTBuilt 1996 · S/N 53011 N407FCIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 1996 · S/N 53050 N407UTMed Trans Corp · Denton, TXBuilt 1996 · S/N 53036 N408AEAir Evac Ems Inc · O Fallon, MOBuilt 2009 · S/N 52408 N409AEAir Evac Ems Inc · O Fallon, MOBuilt 2010 · S/N 52413 N40DVNordstrom Eric Trustee · Anchorage, AKBuilt 1982 · S/N U20606493 N410AEAir Evac Ems Inc · O Fallon, MOBuilt 2012 · S/N 52435 N410SCAlfheim II LLC · Menomonee Falls, WIBuilt 1998 · S/N 5026 N414AEAir Evac Ems Inc · O Fallon, MOBuilt 2009 · S/N 52404 N415AEAir Evac Ems Inc · O Fallon, MOBuilt 2009 · S/N 52399 N416AEAir Evac Ems Inc · O Fallon, MOBuilt 2009 · S/N 52403 N417AEAir Evac Ems Inc · O Fallon, MOBuilt 2014 · S/N 52463 N4180FCaswell Farms · Durham, CABuilt 1991 · S/N 51469 N418AEAir Evac Ems Inc · O Fallon, MOBuilt 2009 · S/N 52405 N419DHAerial Applicators Of Missouri LLC · Qulin, MOBuilt 1984 · S/N 51007 N420AEAir Evac Ems Inc · O Fallon, MOBuilt 2014 · S/N 52461 N422AEAir Evac Ems Inc · O Fallon, MOBuilt 2014 · S/N 52462 N423AEAir Evac Ems Inc · O Fallon, MOBuilt 2011 · S/N 52423 N424AEAir Evac Ems Inc · O Fallon, MOBuilt 2011 · S/N 52424 N424WCWilson Construction Co · Canby, ORBuilt 1988 · S/N 0606FF N426AEAir Evac Ems Inc · O Fallon, MOBuilt 2011 · S/N 52426 N4282ZSayre Stanley · Mantua, OHBuilt 1999 · S/N 51499 N429AEAir Evac Ems Inc · O Fallon, MOBuilt 2011 · S/N 52428 N42FOchoco Wood Products LLC · Prineville, ORBuilt 1994 · S/N 52100 N42SLHelicopters Inc · Wilmington, DEBuilt 2008 · S/N 52377 N430AEAir Evac Ems Inc · O Fallon, MOBuilt 2011 · S/N 52430 N430AGMcmahon Helicopter Services Inc · Canton, MIBuilt 1998 · S/N 49045 N430NYMcmahon Helicopter Services Inc · Canton, MIBuilt 2000 · S/N 49068 N430STHigh Performance Helicopters Corp · Crestline, CABuilt 2000 · S/N 49071 N430VPAerotrust Services Corp Trustee · Wilmington, DES/N 49005 N431AETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 52441 N431HFHeliflite Shares LLC · Newark, NJBuilt 1999 · S/N 49051 N432RDAirdine LLC · San Francisco, CABuilt 2002 · S/N 5039 N4338DAce High Helos LLC · Louise, TXBuilt 1992 · S/N 51560 N434AEAir Evac Ems Inc · Lewisville, TXBuilt 2013 · S/N 52450 N435AEAir Evac Ems Inc · O Fallon, MOBuilt 2012 · S/N 52446 N436AEAir Evac Ems Inc · O Fallon, MOBuilt 2012 · S/N 52447 N437AEAir Evac Ems Inc · Lewisville, TXBuilt 2013 · S/N 52449

Back to AD 81-13-12 R1