Registered aircraft · 70

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-09-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:92-09-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:92-09-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:92-09-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:92-09-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:92-09-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.

N1079UTurbines Ltd · West Point, NEBuilt 1980 · S/N 31122 N143PHWestern USA Solutions Inc · Kodiak, AKS/N 33134 N156MHMansfield Heliflight Inc · Milton, VTS/N 33184 N16920Temsco Helicopters Inc · Ketchikan, AKBuilt 1977 · S/N 30865 N16930Temsco Helicopters Inc · Ketchikan, AKBuilt 1980 · S/N 30920 N17LASan Juan Aviation LLC · Wilmington, DEBuilt 1992 · S/N 36044 N18LACounty Of Los Angeles Fire Department · Pacoima, CABuilt 1992 · S/N 36043 N21221Bank Of Utah Trustee · Salt Lake City, UTBuilt 1976 · S/N 30773 N21225Bank Of Utah Trustee · Salt Lake City, UTBuilt 1981 · S/N 31183 N21240Bank Of Utah Trustee · Salt Lake City, UTBuilt 1976 · S/N 30783 N212AHAspen Helicopters Inc · Oxnard, CABuilt 1979 · S/N 30959 N212BTRedding Air Service Inc · Redding, CABuilt 1978 · S/N 30870 N212DFState Of Nevada · Reno, NVBuilt 1975 · S/N 30676 N212HBBritt Christopher Charles · Bryan, TXBuilt 1982 · S/N 31214 N212HLRogers Helicopters Inc · Fresno, CABuilt 1974 · S/N 30621 N212HPCorpat Inc · Missoula, MTBuilt 1979 · S/N 30951 N212NBA&P Helicopters Inc · Richvale, CAS/N 30599 N212THCougar Aviation LLC · Fresno, CABuilt 1980 · S/N 31109 N212TPNational Test Pilot School · Mojave, CABuilt 1971 · S/N 32003 N216APA&P Helicopters Inc · Richvale, CABuilt 1973 · S/N 30576 N217APCopter Lease LLC Trustee · Albuquerque, NMBuilt 1982 · S/N 31218 N232PJHelibro LLC · Red Bluff, CABuilt 1977 · S/N 30826 N249HVertol Systems Co Inc · Destin, FLBuilt 1993 · S/N 35061 N281SDCity Of San Diego · San Diego, CABuilt 1980 · S/N 31147 N288DLTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 1982 · S/N 32125 N303VSVertol Systems Company Inc · Destin, FLS/N 31303 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 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 N397ALVertol Systems Co LLC · Wilmington, DEBuilt 1990 · S/N 36012 N402ESNorth Slope Borough · Barrow, AKBuilt 1988 · S/N 33177 N411DEU S Department Of Energy · Las Vegas, NVBuilt 1991 · S/N 36030 N41VSVertol Systems Co Inc · Destin, FLS/N 31151 N4359FPetroleum Helicopter Technology Inc · San Antonio, TXS/N 31117 N470QLVertol Systems Co Inc · Destin, FLBuilt 1989 · S/N 33200 N500EHHilcorp Equipment LLC · Anchorage, AKS/N 30945 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 N612TABlackbird LLC · Irvine, CABuilt 1974 · S/N 30624 N621FCFlorida Depart Of Agriculture And Consumer Svcs · Tallahassee, FLBuilt 1991 · S/N 35034 N622FCRegistered aircraftN-number assigned, not yet registeredS/N 35048 N624FCFlorida Forest Service - Fp/Ac · Tallahassee, FLBuilt 1993 · S/N 35060

Back to AD 92-09-05