Registered aircraft · 480

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-23-01') 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-23-01') 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-23-01')
    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-23-01')
  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-23-01')
  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-23-01')
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.

N1022QAmerican Huey 369 Inc · Peru, INBuilt 1964 · S/N 64-14049 N102FWSierra Aeronautics LLC · Franklin, KYS/N 62-1905 N10432Huey 197 LLC · Argyle, TXBuilt 1968 · S/N 68-16197 N1044QReynolds Darryl G · Wills Point, TXS/N 66-17100 N104HFArmy Aviation Heritage Foundation · Hampton, GABuilt 1968 · S/N 68-16104 N105NJUsda Forest Service Fepp · Trenton, NJS/N 66-17071 (9265)N106NJUsda Forest Service Fepp · Trenton, NJS/N 66-16030 (5724)N1079UTurbines Ltd · West Point, NEBuilt 1980 · S/N 31122 N107BZCounty Of San Diego · El Cajon, CABuilt 1968 · S/N 30013 N107CHAirlift Helicopters Services · Seal Beach, CABuilt 1967 · S/N 67-17290 N107NJUsda Forest Service · Trenton, NJS/N 13682 N1081CCelebrate Freedom Foundation Inc · West Columbia, SCBuilt 1973 · S/N 73-21685 N109MAMinuteman Aviation Inc · Missoula, MTBuilt 1968 · S/N 68-15334 N10RFBrown Helicopter Inc · Pensacola, FLBuilt 1973 · S/N 73-21715 N10WUBell Textron Inc · Fort Worth, TXS/N 7120010 N110NWCbft LLC · Mobile, ALBuilt 1966 · S/N 66-16198 N111DRNorthwest Helicopters I Inc · Olympia, WABuilt 1996 · S/N 64-13699 N111UDDrive A Tank Inc · Kasota, MNS/N 70-16357 N113FDSacramento Metropolitan Fire District · Mather, CAS/N 70-16370 N1145QBrown Helicopter Inc · Pensacola, FLBuilt 1966 · S/N 66-16355 N114DRNorthwest Helicopters I Inc · Olympia, WABuilt 1995 · S/N 66-00792 N114FDSacramento Metropolitan Fire District · Mather, CAS/N 72-21558 N115FDSacramento Metropolitan Fire District · Mather, CAS/N 74-22330 N117DRNorthwest Helicopters I Inc · Olympia, WABuilt 1995 · S/N 65-12871 N118DRHeli-Huey Corp · El Paso, TXNon-citizen corporation, flight hours not reportedS/N 66-00903 N11NENorthern X Treme Helicopters Inc · Gridley, CABuilt 2001 · S/N 63-13086 N120FCUsda Forest Service Fepp · Tallahassee, FLS/N 70-16260 N120SHHelicopter Applicators Inc · Gettysburg, PABuilt 1972 · S/N 30119 N1215FJzw Aviation LLC · North Salt Lake, UTBuilt 1964 · S/N 64-13688 N121PTLrh Equipment LLC · Pendleton, ORBuilt 1964 · S/N 64-13711 N124FCUsda Forest Service Fepp · Tallahassee, FLS/N 64-13750 N124PTRegistration Pending · Bonners Ferry, IDRegistration pendingS/N 63-08817 N128FCAllied Response Inc · Copperas Cove, TXS/N 69-15848 N129SPNew York State Police · Albany, NYS/N 70-16205 N1304XNorthwest Helicopters LLC · Olympia, WAS/N 3169 N133Brown Helicopter Inc · Pensacola, FLBuilt 1966 · S/N 65-09847 N1363WWithrotor Aviation Inc · Lakeview, ORBuilt 1966 · S/N 66-16854 N143SPRegenald Michaud Aviation LLC · Willows, CAS/N 66-01065 N145MAMinuteman Aviation Inc · Missoula, MTBuilt 1972 · S/N 72-21584 N14SDLake County Sheriffs Office · Tavares, FLBuilt 1962 · S/N 62-12369 N15HXHelicopter Express LLC · Chamblee, GABuilt 1972 · S/N 30117 N16315Army Aviation Heritage Foundation And Flg Museum · Hampton, GABuilt 1971 · S/N 70-16315 N16493Astre Air International · Watkins, COS/N 66-16493 N166DROas2 LLC · Orlando, FLBuilt 1995 · S/N 66-16949 N16920Temsco Helicopters Inc · Ketchikan, AKBuilt 1977 · S/N 30865 N16930Temsco Helicopters Inc · Ketchikan, AKBuilt 1980 · S/N 30920 N16HXHelicopter Express LLC · Chamblee, GABuilt 1979 · S/N 30293 N174SPNew York State Police · Albany, NYS/N 63-12997 N17HXHelicopter Express LLC · Chamblee, GABuilt 1975 · S/N 30217 N186SDOrange County Sheriffs Dept · Costa Mesa, CAS/N 74-22540

Back to AD 92-23-01