Registered aircraft · 366

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:84-12-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:84-12-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:84-12-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:84-12-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:84-12-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:84-12-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.

N500BHAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1998 · S/N 0537E N500DCHva Holdings LLC · Gettysburg, PABuilt 1978 · S/N 290456D N500EKKar Aviation LLC · Saltville, VABuilt 1979 · S/N 1190610D N500EVSnohomish County Sheriff · Snohomish, WABuilt 1989 · S/N 0340E N500FCFerguson And Sons Construction LLC · Emmett, IDBuilt 1983 · S/N 0442E N500FFRegistered aircraftN-number assigned (import), not yet registeredS/N 1270251D N500GKN969md Inc · Middletown, DES/N 911074-D N500HJ392e Inc Trustee · Wilmington, DEBuilt 1990 · S/N 0392E N500HWHeliwild Investments LLC · Austin, TXBuilt 1978 · S/N 480294D N500KYRotor Imaging LLC · Reading, PABuilt 1989 · S/N 0345E N500LKWinco Inc · Aurora, ORBuilt 1983 · S/N 0009E N500MUHva Inc · Summersville, WVBuilt 1996 · S/N 0533E N500MVTreeline Helicopters Inc · Bristol, TNBuilt 1977 · S/N 770156D N500NCSanders Associates LLC · Bluefield, VABuilt 1977 · S/N 1260052D N500PHPrecision Heli-Support LLC · Mesa, AZS/N 0187E N500RMHawkeye Helicopter LLC · Lyndon, KSS/N 0119E N500SLPatriot Marine LLC · New Haven, CTBuilt 1988 · S/N 0309E N500SYNalas Inc Trustee · Wilmington, DEBuilt 1983 · S/N 0007E N500TNOnespan Powerline Services LLC · Peachtree City, GABuilt 1979 · S/N 590521D N500TYSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1984 · S/N 0086E N500TZGulf Helicopters LLC · Santa Fe, TXBuilt 1979 · S/N 590507D N500VSVertol Systems Company Inc · Destin, FLBuilt 1977 · S/N 170072D N500WXTre Aviation Corp · Wilmington, DEBuilt 1992 · S/N 0493E N500XVSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1980 · S/N 1200881D N501EFAirwest Helicopters Inc · Redlands, CABuilt 1977 · S/N 270091D N501HPHonolulu Police Department · Honolulu, HIBuilt 2009 · S/N 0593E N501MDAgricultural Air Services LLC · Jupiter, FLBuilt 1991 · S/N 0485E N501RMCity Of Pasadena · Pasadena, CABuilt 2009 · S/N 0598E N501VSVertol Systems Co Inc · Destin, FLBuilt 1977 · S/N 170050D N5027PBank Of Utah Trustee · Salt Lake City, UTBuilt 1981 · S/N 611002D N502CHVertol Systems Co Inc · Destin, FLBuilt 1978 · S/N 180252D N502HBActive Aviation LLC · Newark, DEBuilt 1978 · S/N 480291D N502HPHonolulu Police Department · Honolulu, HIBuilt 2007 · S/N 0572E N502MMWinco Inc · Aurora, ORS/N 1170229D N502SLSc Law Enforcement Division · Columbia, SCS/N 0244E N504EFAirwest Helicopters Inc · Redlands, CAS/N 0500E N504SLSouth Carolina Law Enforcement Division · Columbia, SCBuilt 2014 · S/N 0621E N5063GCedar Helicopters LLC · Shelton, WAS/N 711021D N506MPCity Of Mesa · Mesa, AZBuilt 1998 · S/N 0541E N50713Hlh Leasing LLC · Wilmington, DES/N 710982D N5072FWinco Inc · Aurora, ORS/N 811024D N5074LHigh Life Helicopters LLC · Kalispell, MTS/N 811051D N507HWHeliwild Investments LLC · Austin, TXBuilt 1977 · S/N 1270243D N507TVShoreline Aircraft Leasing LLC · Lewes, DES/N 0226E N508PHApex Heli-Support LLC · Phoenix, AZS/N 0182E N50APBank Of Utah Trustee · Salt Lake City, UTBuilt 1979 · S/N 1090585D N50QDNorth Fork Helicopters Ltd · Cutchogue, NYBuilt 1979 · S/N 390478D N50XBRwb 66 LLC · Victoria, TXBuilt 2018 · S/N 0624E N5106YSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1981 · S/N 811057D N5108ECorporate Leasing Services LLC · Helena, MTBuilt 1981 · S/N 811075D

Back to AD 84-12-01 R1