Registered aircraft · 378

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

N40707Slaney Richard C · Eugene, ORS/N 66-01136 N40722West Valley Aviation Inc · Five Points, CABuilt 1969 · S/N 69-15256 N40729Hlh Leasing LLC · Wilmington, DES/N 69-15233 N407KCUsda Forest Service · Bakersfield, CAS/N 66-16401 N408KCUsda Forest Service-Fepp · Bakersfield, CAS/N 67-17725 N41109Lrh Equipment LLC · Pendleton, ORS/N 11968 N415NABig Turbine Engines LLC · Wilmington, DEBuilt 1965 · S/N 65-10085 N417NAVi 1 LLC · Brewster, WABuilt 1965 · S/N 64-13628 N41909Lrh Equipment LLC · Pendleton, ORS/N 7321809 N420NABrown Helicopter Inc · Pensacola, FLS/N 65-10104 N421NCState Of North Carolina · Raleigh, NCBuilt 1964 · S/N 64-13544 N4237VRatledge Thomas D · Bethel, AKS/N 261 N424NAJones Flying Service Inc · Biggs, CAS/N 6414021 N426HFArmy Aviation Heritage Foundation Inc · Hampton, GABuilt 1970 · S/N 70-16426 N430BHBering Air Inc · Nome, AKBuilt 1965 · S/N 65-09702 N4316NRegistration Pending · Horseshoe Bay, TXRegistration pendingBuilt 1977 · S/N 13900 N431LHDs Flight Services LLC · Battle Ground, WABuilt 1971 · S/N 71-20257 N431XHGrayman Group LLC · Coeur D Alene, IDBuilt 1977 · S/N 13892 N431ZHNixon Helicopters LLC · Mentone, CABuilt 1977 · S/N 13902 N432EBRs Aviation LLC · Washington, PABuilt 1977 · S/N 13903 N432FNCommerce Rotorcraft LLC · Commerce, TXBuilt 1977 · S/N 13904 N432GCHelicopter Aviation Services & Leasing Inc · Boynton Beach, FLBuilt 1977 · S/N 13907 N432JCNixon Helicopters LLC · Mentone, CABuilt 1977 · S/N 13893 N432KNNorthwest Helicopters LLC · Olympia, WAS/N 13901 N433ZNNorthwest Helicopters LLC · Olympia, WAS/N 71-20170 N4391WUS Dept Of State · Melbourne, FLS/N 67-17224 N440VRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 66-16899 N441FAUsda Forest Service Fepp · Irvine, CAS/N 66-01127 N4432WNorthwest Helicopters LLC · Olympia, WAS/N 68-15784 N4439BRegistration Pending · Mount Pleasant, TXRegistration pending, pending cancellationBuilt 1968 · S/N 68-15419 N443YBNorthwest Helicopters LLC · Olympia, WABuilt 1968 · S/N 68-16261 N443ZBPleasant Aviation LLC · Mount Pleasant, TXBuilt 1967 · S/N 67-17238 N444BBWarbirds-3 LLC · Kalispell, MTBuilt 1967 · S/N 67-17364 N444SJJones Flying Service · Biggs, CABuilt 1962 · S/N 391 N444XLPacific Valley Aviation Inc · Arbuckle, CABuilt 1967 · S/N 67-17160 N4480Twin Cities Aviation Inc · Yuba City, CAS/N 64-13906 N453CCHelo 1 LLC · Anchorage, AKBuilt 1968 · S/N 155352 N45731Magnum Aviation LLC · Goff, KSS/N 61-0750 N45855Scotts Helicopter Service Inc · Le Sueur, MNS/N 62-1991 N458CCElkhorn Aviation Inc · Baker City, ORBuilt 1967 · S/N 67-17678 N45SPKentucky State Police · Frankfort, KYS/N 70-16413 N461CCAvag Inc · Richvale, CABuilt 1967 · S/N 67-17162 N467WWFriends Of Army Aviation-Ozark · Ozark, ALBuilt 1970 · S/N 7016467 N46928Scotts Helicopter Services Inc · Le Sueur, MNS/N 61-0712 N46969R & R Conner Aviation LLC · Conner, MTS/N 63-8548 N474THTop Hand Inc · Laurel, MTBuilt 1968 · S/N 68-15474 N488DFUsda Forest Service Fepp · Mcclellan, CAS/N 69-15239 N490DFUsda Forest Service Fepp · Mcclellan, CAS/N 70-15765 N498DFUsda Forest Service Fepp · Mcclellan, CAS/N 69-15865 N499DFUsda Forest Service Fepp · Mcclellan, CAS/N 71-20022

Back to AD 2000-15-21 R1