Registered aircraft · 126

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

N288DLTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 1982 · S/N 32125 N28HXHelicopter Express LLC · Chamblee, GABuilt 1968 · S/N 30034 N303VSVertol Systems Company Inc · Destin, FLS/N 31303 N304HALyons Aircraft Leasing LLC · Hillsboro, ORBuilt 1972 · S/N 30110 N307SBSan Bernardino County Sheriffs Aviation Division · San Bernardino, CABuilt 1975 · S/N 30781 N310MPSuperior Aviation Solutions LLC · Mooresville, NCBuilt 1981 · S/N 31207 N316LHLohman Helicopter LLC · Lewiston, IDBuilt 1977 · S/N 30817 N32240Ventura County Sheriffs Department · Camarillo, CABuilt 1981 · S/N 30012 N334MPPope James Dean · Lewiston, IDS/N 30274 N336MPPope James Dean · Lewiston, IDS/N 30107 N338MPPope James Dean · Lewiston, IDS/N 30278 N33HXCopter Lease LLC Trustee · Albuquerque, NMBuilt 1976 · S/N 30235 N359EHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1972 · S/N 30546 N369ECEcolift Corp · San Juan, PRS/N 30671 N373PACopter Lease LLC Trustee · Albuquerque, NMBuilt 1979 · S/N 30934 N374PACopter Lease LLC Trustee · Albuquerque, NMBuilt 1979 · S/N 30931 N376PAPathfinder Leasing LLC · Anchorage, AKBuilt 1978 · S/N 30886 N378PACopter Lease LLC Trustee · Albuquerque, NMBuilt 1974 · S/N 30629 N37HXHelicopter Express LLC · Chamblee, GAS/N 30038 N3803CState Of Colorado Department Of Public Safety · Lakewood, COBuilt 1968 · S/N 30006 N3804CState Of Colorado Department Of Public Safety · Lakewood, COBuilt 1980 · S/N 30314 N380PLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1975 · S/N 30209 N404HAHillsboro Aviation Inc · Hillsboro, ORBuilt 1979 · S/N 30295 N41VSVertol Systems Co Inc · Destin, FLS/N 31151 N41WLCopter Lease LLC Trustee · Albuquerque, NMS/N 30262 N4218SAgriforrestal Applications Inc · Arcadia, FLS/N 30084 N4359FPetroleum Helicopter Technology Inc · San Antonio, TXS/N 31117 N449RCCounty Of San Diego · El Cajon, CABuilt 1973 · S/N 30121 N456TARoberts Aircraft LLC · Cheyenne, WYBuilt 1975 · S/N 30175 N500EHHilcorp Equipment LLC · Anchorage, AKS/N 30945 N502THTemsco Helicopters Inc · Ketchikan, AKBuilt 1969 · S/N 30030 N508EHHilcorp Equipment LLC · Anchorage, AKBuilt 1979 · S/N 30908 N512PAPatriot Aviation Inc · Greenville, DEBuilt 1984 · S/N 31268 N515Savauge Air LLC · North Las Vegas, NVBuilt 1975 · S/N 30759 N530NCCopter Lease LLC Trustee · Albuquerque, NMBuilt 1972 · S/N 30544 N534HQTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1973 · S/N 30142 N534NCCopter Lease LLC Trustee · Albuquerque, NMBuilt 1974 · S/N 30172 N549RLAircraft Trustee Services Inc Trustee · Dover, DES/N 30215 N551HQTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 30088 N580SHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1979 · S/N 30294 N612TABlackbird LLC · Irvine, CAFirst renewal noticeBuilt 1974 · S/N 30624 N621FCFlorida Depart Of Agriculture And Consumer Svcs · Tallahassee, FLBuilt 1991 · S/N 35034 N6226HMagnum Aviation LLC · Goff, KSS/N 2046 N622FCRegistered aircraftN-number assigned, not yet registeredS/N 35048 N624FCFlorida Forest Service - Fp/Ac · Tallahassee, FLBuilt 1993 · S/N 35060 N626FCFlorida Department Of Agriculture And Consumer · Tallahassee, FLBuilt 1995 · S/N 35088 N669HV2plus 1 LLC · Homer, AKBuilt 1974 · S/N 30171 N66HJEcho Foxtrot Holdings LLC · Lewes, DEBuilt 1976 · S/N 30239 N679HHillcrest Aircraft Co · Lewiston, IDBuilt 1974 · S/N 30164 N67FURotak LLC · Anchorage, AKBuilt 1967 · S/N 2064

Back to AD 2000-08-52