Registered aircraft · 484

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:2002-13-05-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:2002-13-05-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:2002-13-05-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:2002-13-05-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:2002-13-05-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:2002-13-05-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.

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 N500TVTennessee Valley Authority · Muscle Shoals, ALBuilt 2019 · S/N 0320FF 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 N505MPCity Of Mesa Police Dept · Mesa, AZBuilt 2001 · S/N 0722FF 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 N507MPMesa Police Dept · Mesa, AZBuilt 2015 · S/N 0226FF 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 N510PACedar Helicopters LLC · Shelton, WABuilt 1981 · S/N 811073D N510PDCity Of Oakland · Oakland, CABuilt 1990 · S/N 0400E

Back to AD 2002-13-05 R1