Registered aircraft · 207

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

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 N216GHRotorcraft Support Inc · Fillmore, CABuilt 1969 · S/N 30036 N217APCopter Lease LLC Trustee · Albuquerque, NMBuilt 1982 · S/N 31218 N21844Los Angeles Police Dept Air Support Division · Los Angeles, CABuilt 1999 · S/N 36229 N219MGAir Methods LLC · Greenwood Village, COBuilt 1998 · S/N 36218 N223HTHillsboro Aviation Inc · Hillsboro, ORBuilt 1975 · S/N 30180 N225PRWindsock Management LLC · Little Rock, ARBuilt 1976 · S/N 30230 N228SPSamaritans Purse · Boone, NCBuilt 2010 · S/N 36548 N229HTVertical Corp · Kalispell, MTBuilt 1980 · S/N 30330 N22PPDepartment Of Interior · Boise, IDBuilt 1998 · S/N 36219 N232PJHelibro LLC · Red Bluff, CABuilt 1977 · S/N 30826 N233LCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 36269 N241FAOrange County Fire Authority · Irvine, CABuilt 2008 · S/N 36487 N249HVertol Systems Co Inc · Destin, FLBuilt 1993 · S/N 35061 N2773HSummit Helicopters Inc · Salem, VABuilt 1979 · S/N 30296 N281SDCity Of San Diego · San Diego, CABuilt 1980 · S/N 31147 N282SDCity Of San Diego · San Diego, CABuilt 2008 · S/N 36466 N284SDCity Of San Diego Fire-Rescue Dept · San Diego, CABuilt 2024 · S/N 39132 N288DLTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 1982 · S/N 32125 N28HXHelicopter Express LLC · Chamblee, GABuilt 1968 · S/N 30034 N28VAVirginia State Police · Richmond, VABuilt 2019 · S/N 37045 N300SJBell Textron Inc · Fort Worth, TXBuilt 2025 · S/N 39142 N303VSVertol Systems Company Inc · Destin, FLS/N 31303 N304HALyons Aircraft Leasing LLC · Hillsboro, ORBuilt 1972 · S/N 30110 N306SBSan Bernardiino County Sheriffs Dept · San Bernardino, CABuilt 2023 · S/N 39116 N307SBSan Bernardino County Sheriffs Aviation Division · San Bernardino, CABuilt 1975 · S/N 30781 N308SBSan Bernardino County Sheriffs Dept · San Bernardino, CABuilt 2023 · S/N 39114 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 N34JJWestern USA Solutions Inc · Kodiak, AKS/N 36125 N359EHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1972 · S/N 30546 N366MRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 36676 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 N377AFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 37030

Back to AD 2012-22-06