Registered aircraft · 164

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:97-21-07-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:97-21-07-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:97-21-07-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:97-21-07-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:97-21-07-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:97-21-07-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.

N534NCCopter Lease LLC Trustee · Albuquerque, NMBuilt 1974 · S/N 30172 N540FUAdf Helicopters Inc · Brewster, WABuilt 1999 · S/N 157190 N549RLAircraft Trustee Services Inc Trustee · Dover, DES/N 30215 N574PDRegistration Pending · Arbuckle, CARegistration pendingBuilt 1968 · S/N 68-16574 N58468Long-Line Leasing LLC · Saratoga Springs, UTBuilt 1971 · S/N 71-20298 N599HFNext Level Marine LLC · Mount Pleasant, TXBuilt 1976 · S/N 76-22599 N59HPHansen Albert C · Mojave, CABuilt 1962 · S/N 62-1933 N606HFAgriforrestal Applications Inc · Cape Coral, FLS/N 638606 N61650Great Falls Property LLC · Auburn, MEBuilt 1997 · S/N 157184 N6180AJones Aviation Inc · Biggs, CABuilt 1962 · S/N 62-1994 N6257PPremier Aircraft Services LLC · Bakersfield, CABuilt 1963 · S/N 63-08807 N6261CVi1 LLC · Brewster, WABuilt 1968 · S/N 68-15521 N62767Aquila Helicopters LLC · Elliston, MTS/N 62-1915 N638HAHelicopter Applicators Inc · Gettysburg, PABuilt 1966 · S/N 67-17302 N64770Premier Aircraft Services LLC · Bakersfield, CABuilt 1964 · S/N 63-8721 N648HAHelicopter Applicators Inc · Gettysburg, PABuilt 1965 · S/N 64-13888 N661UHRegistration Pending · Midlothian, TXRegistration pendingBuilt 1966 · S/N 66-16782 N669HV2plus 1 LLC · Homer, AKBuilt 1974 · S/N 30171 N66HJEcho Foxtrot Holdings LLC · Lewes, DEBuilt 1976 · S/N 30239 N674THTimberline Helicopters Inc · Sandpoint, IDBuilt 2004 · S/N A94-0035 N675THTimberline Helicopters Inc · Sandpoint, IDBuilt 1998 · S/N A94-0025 N67NHState Of North Carolina · Raleigh, NCBuilt 1967 · S/N 6717282 N67SHNorthwest Helicopters LLC · Olympia, WABuilt 1976 · S/N 7622707 N6828Northwest Helicopters LLC · Olympia, WABuilt 1966 · S/N 66-00828 N689HHillcrest Aircraft Co Inc · Lewiston, IDBuilt 1979 · S/N 30289 N68ECCopter Lease LLC Trustee · Albuquerque, NMBuilt 1968 · S/N 30008 N7042LSouthwest Florida Aviation · Arcadia, FLS/N 70-16398 N7042NAgriforrestal Applications Inc · Arcadia, FLS/N 64-13667 N710WDA&P Helicopters Inc · Richvale, CAS/N 65-09761 N714MQHaus Michael D · Concord, CABuilt 1965 · S/N 65-09576 N7239LWallasch Charles Trustee · Alpine, WYBuilt 1976 · S/N 76-22601 N7239TOlympic Jet Inc · Olympia, WABuilt 1977 · S/N 77-22741 N730VBAsa Security LLC · Anchorage, AKBuilt 1965 · S/N 65-9992 N737HFSpitfire Ventures LLC · San Antonio, TXBuilt 1967 · S/N 67-15737 N750HPRegistration Pending · Knoxville, TNRegistration pendingBuilt 1970 · S/N 70-16409 N75462Brown Helicopter Inc · Pensacola, FLBuilt 1974 · S/N 74-22351 N767NADh Helicopter Inc · Whitefield, MEBuilt 2022 · S/N A94-0049 N771ARVertical Access Corp · Lewes, DES/N 66-00906 N777GHRugged Flightworks LLC · Big Piney, WYBuilt 1964 · S/N 64-13560 N806SBScotts Helicopter Service · Le Sueur, MNBuilt 1964 · S/N 64-14023 N82276Air Cav Helicopters LLC · Wilmington, DEBuilt 1976 · S/N 76-22695 N826HFArmy Aviation Hertiage Foundation And Museum · Hampton, GABuilt 1967 · S/N 67-15826 N832DHSkyhop LLC · Santa Rosa, CABuilt 1967 · S/N 67-17659 N839PFRice Aircraft Services Inc · Olivehurst, CABuilt 1970 · S/N 8232 N841MRock Creek Leasing LLC · Sapulpa, OKBuilt 1962 · S/N 62-1956 N849DBD & B Aviation Brokerage Services LLC · Wilmington, DEBuilt 1970 · S/N 8494 N850MJones Aviation · Biggs, CABuilt 1966 · S/N 66-16875 N87LHHill Lawrence E · Marion, MTBuilt 1971 · S/N 30087 N88976R Consulting & Sales Inc · Carson City, NVS/N 64-14009 N88992Premier Aircraft Services LLC · Bakersfield, CABuilt 1961 · S/N 61-0718

Back to AD 97-21-07 R1