Registered aircraft · 124

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:88-25-05') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:88-25-05') 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:88-25-05')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:88-25-05')
  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:88-25-05')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:88-25-05')
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 N107BZCounty Of San Diego · El Cajon, CABuilt 1968 · S/N 30013 N11NENorthern X Treme Helicopters Inc · Gridley, CABuilt 2001 · S/N 63-13086 N120SHHelicopter Applicators Inc · Gettysburg, PABuilt 1972 · S/N 30119 N1304XNorthwest Helicopters LLC · Olympia, WAS/N 3169 N137USThomas Aviation LLC · Orleans, CABuilt 1965 · S/N 151874 N154TLJtbam Inc · Lakeside, AZBuilt 1988 · S/N 154770 N155TLTwo Roan Ranch LLC · Salem, ORBuilt 1967 · S/N 154779 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 N1MXWsh LLC · Palmer, AKS/N 62-01995 N204AQTamarack Helicopters Inc · Stevensville, MTS/N 2198 N204BSIntermountain Helicopters Inc · Cottage Grove, ORBuilt 1963 · S/N 63-8699 N204DSGreenwood Helicopters Inc · Washington, NCBuilt 1960 · S/N 60-3594 N204DXFarwest Aviation LLC · Billings, MTS/N 61-787 N204GPJones Aviation Inc · Biggs, CABuilt 1964 · S/N 64-14073 N204HTJones Flying Service · Biggs, CABuilt 1962 · S/N 62-2078 N204JBPremier Aircraft Services LLC · Bakersfield, CABuilt 1963 · S/N 63-13088 N204NWNorthwest Helicopters LLC · Olympia, WAS/N 2050 N204RARotak LLC · Anchorage, AKBuilt 1965 · S/N 2034 N204UHR&R Conner Aviation LLC · Conner, MTBuilt 1962 · S/N 62-2034 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 N205WWBlades LLC · Arlington, WABuilt 1980 · S/N 30329 N206NJPope James D · Clarkston, WABuilt 1962 · S/N 62-1934 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 N2252APremier Aircraft Services LLC · Bakersfield, CABuilt 1961 · S/N 61-0798 N225PRWindsock Management LLC · Little Rock, ARBuilt 1976 · S/N 30230 N22753Martins Dusters Inc · Colusa, CABuilt 1964 · S/N 64-13985 N229HTVertical Corp · Kalispell, MTBuilt 1980 · S/N 30330 N234SJPorter Flying Services Inc · Chico, CABuilt 1962 · S/N 388 N271GHAmerican Huey 369 Inc · Peru, INS/N 151271 N2773HSummit Helicopters Inc · Salem, VABuilt 1979 · S/N 30296 N28HXHelicopter Express LLC · Chamblee, GABuilt 1968 · S/N 30034 N2956FAvag Inc · Richvale, CAS/N 63-12950

Back to AD 88-25-05