Registered aircraft · 60

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

N107BZCounty Of San Diego · El Cajon, CABuilt 1968 · S/N 30013 N120SHHelicopter Applicators Inc · Gettysburg, PABuilt 1972 · S/N 30119 N15HXHelicopter Express LLC · Chamblee, GABuilt 1972 · S/N 30117 N16HXHelicopter Express LLC · Chamblee, GABuilt 1979 · S/N 30293 N17HXHelicopter Express LLC · Chamblee, GABuilt 1975 · S/N 30217 N205ATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1974 · S/N 30161 N205BDVentus Ff LLC · Boise, IDBuilt 1971 · S/N 30097 N205BTRedding Air Service Inc · Redding, CABuilt 1974 · S/N 30173 N205CESouthern California Edison Co · Rosemead, CABuilt 1980 · S/N 30301 N205DYIdaho Helicopters Inc · Boise, IDBuilt 1978 · S/N 30282 N205GFGeorgia Forestry Commission · Macon, GABuilt 1979 · S/N 30300 N205GHRotorcraft Support Inc · Fillmore, CABuilt 1968 · S/N 30014 N205HQTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1970 · S/N 30100 N205LMVentus Ff LLC · Boise, IDBuilt 1974 · S/N 30213 N205RHSacramento Executive Helicopters Inc · Rancho Cordova, CABuilt 1973 · S/N 30127 N205TARoberts Aircraft LLC · Cheyenne, WYBuilt 1974 · S/N 30168 N205TKCoastal Helicopters LLC · La Verne, CABuilt 1973 · S/N 30131 N205VCVentura County Sheriffs Department · Camarillo, CABuilt 1969 · S/N 30066 N205WWBlades LLC · Arlington, WABuilt 1980 · S/N 30329 N211GHGuardian Helicopters Inc · Fillmore, CAS/N 30058 N211NWOlympic Jet Inc · Olympia, WABuilt 1975 · S/N 30177 N216GHRotorcraft Support Inc · Fillmore, CABuilt 1969 · S/N 30036 N223HTHillsboro Aviation Inc · Hillsboro, ORBuilt 1975 · S/N 30180 N225PRWindsock Management LLC · Little Rock, ARBuilt 1976 · S/N 30230 N229HTVertical Corp · Kalispell, MTBuilt 1980 · S/N 30330 N2773HSummit Helicopters Inc · Salem, VABuilt 1979 · S/N 30296 N28HXHelicopter Express LLC · Chamblee, GABuilt 1968 · S/N 30034 N304HALyons Aircraft Leasing LLC · Hillsboro, ORBuilt 1972 · S/N 30110 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 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 N41WLCopter Lease LLC Trustee · Albuquerque, NMS/N 30262 N4218SAgriforrestal Applications Inc · Arcadia, FLS/N 30084 N449RCCounty Of San Diego · El Cajon, CABuilt 1973 · S/N 30121 N456TARoberts Aircraft LLC · Cheyenne, WYBuilt 1975 · S/N 30175 N502THTemsco Helicopters Inc · Ketchikan, AKBuilt 1969 · S/N 30030 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 N669HV2plus 1 LLC · Homer, AKBuilt 1974 · S/N 30171 N66HJEcho Foxtrot Holdings LLC · Lewes, DEBuilt 1976 · S/N 30239

Back to AD 92-27-21