AD 2002-03-01

Registered aircraft · 153

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

N599HFNext Level Marine LLC · Mount Pleasant, TXBuilt 1976 · S/N 76-22599N59HPHansen Albert C · Mojave, CABuilt 1962 · S/N 62-1933N606HFAgriforrestal Applications Inc · Cape Coral, FLS/N 638606N610WWBlades LLC · Arlington, WABuilt 2008 · S/N 21004N61650Great Falls Property LLC · Auburn, MEBuilt 1997 · S/N 157184N6180AJones Aviation Inc · Biggs, CABuilt 1962 · S/N 62-1994N6257PPremier Aircraft Services LLC · Bakersfield, CABuilt 1963 · S/N 63-08807N6261CVi1 LLC · Brewster, WABuilt 1968 · S/N 68-15521N62767Aquila Helicopters LLC · Elliston, MTS/N 62-1915N638HAHelicopter Applicators Inc · Gettysburg, PABuilt 1966 · S/N 67-17302N64770Premier Aircraft Services LLC · Bakersfield, CABuilt 1964 · S/N 63-8721N648HAHelicopter Applicators Inc · Gettysburg, PABuilt 1965 · S/N 64-13888N661UHRegistration Pending · Midlothian, TXRegistration pendingBuilt 1966 · S/N 66-16782N669HV2plus 1 LLC · Homer, AKBuilt 1974 · S/N 30171N66HJEcho Foxtrot Holdings LLC · Lewes, DEBuilt 1976 · S/N 30239N674THTimberline Helicopters Inc · Sandpoint, IDBuilt 2004 · S/N A94-0035N679HHillcrest Aircraft Co · Lewiston, IDBuilt 1974 · S/N 30164N67FURotak LLC · Anchorage, AKBuilt 1967 · S/N 2064N6828Northwest Helicopters LLC · Olympia, WABuilt 1966 · S/N 66-00828N68ECCopter Lease LLC Trustee · Albuquerque, NMBuilt 1968 · S/N 30008N7042LSouthwest Florida Aviation · Arcadia, FLS/N 70-16398N7042NAgriforrestal Applications Inc · Arcadia, FLS/N 64-13667N710WDA&P Helicopters Inc · Richvale, CAS/N 65-09761N714MQHaus Michael D · Concord, CABuilt 1965 · S/N 65-09576N730VBAsa Security LLC · Anchorage, AKBuilt 1965 · S/N 65-9992N737HFSpitfire Ventures LLC · San Antonio, TXBuilt 1967 · S/N 67-15737N750HPRegistration Pending · Knoxville, TNRegistration pendingBuilt 1970 · S/N 70-16409N75462Brown Helicopter Inc · Pensacola, FLBuilt 1974 · S/N 74-22351N771ARVertical Access Corp · Lewes, DES/N 66-00906N775BBCopter Lease LLC Trustee · Albuquerque, NMBuilt 1977 · S/N 30252N806SBScotts Helicopter Service · Le Sueur, MNBuilt 1964 · S/N 64-14023N82276Air Cav Helicopters LLC · Wilmington, DEBuilt 1976 · S/N 76-22695N826HFArmy Aviation Hertiage Foundation And Museum · Hampton, GABuilt 1967 · S/N 67-15826N839PFRice Aircraft Services Inc · Olivehurst, CABuilt 1970 · S/N 8232N841MRock Creek Leasing LLC · Sapulpa, OKBuilt 1962 · S/N 62-1956N849DBD & B Aviation Brokerage Services LLC · Wilmington, DEBuilt 1970 · S/N 8494N850MJones Aviation · Biggs, CABuilt 1966 · S/N 66-16875N87LHHill Lawrence E · Marion, MTBuilt 1971 · S/N 30087N88976R Consulting & Sales Inc · Carson City, NVS/N 64-14009N88992Premier Aircraft Services LLC · Bakersfield, CABuilt 1961 · S/N 61-0718N893PMPorter Flying Service · Durham, CABuilt 1962 · S/N 62-1923N911RQSimmons Robert J · Hayward, CAS/N 66-16298N91320Avag Inc · Richvale, CABuilt 1962 · S/N 62-1887N92530S W Florida Aviation International Inc · Arcadia, FLFirst renewal noticeBuilt 1969 · S/N 11445N933CHCoastal Helicopters LLC · La Verne, CABuilt 1969 · S/N 30062N94NWNorthwest Helicopters I Inc · Olympia, WABuilt 1996 · S/N 66-01101N96ECAv8-Orr Helicopter Services Inc · Hamilton, MTBuilt 1968 · S/N 68-16596N97NWNorthwest Helicopters LLC · Olympia, WABuilt 1965 · S/N 65-09823N98NWPope James D · Clarkston, WABuilt 1964 · S/N 64-13822N99021Magnum Aviation LLC · Goff, KSBuilt 1965 · S/N 64-13949
Back to AD 2002-03-01