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.
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
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.
N599HFNext Level Marine LLC · Mount Pleasant, TXN59HPHansen Albert C · Mojave, CAN606HFAgriforrestal Applications Inc · Cape Coral, FLN610WWBlades LLC · Arlington, WAN61650Great Falls Property LLC · Auburn, MEN6180AJones Aviation Inc · Biggs, CAN6257PPremier Aircraft Services LLC · Bakersfield, CAN6261CVi1 LLC · Brewster, WAN62767Aquila Helicopters LLC · Elliston, MTN638HAHelicopter Applicators Inc · Gettysburg, PAN64770Premier Aircraft Services LLC · Bakersfield, CAN648HAHelicopter Applicators Inc · Gettysburg, PAN661UHRegistration Pending · Midlothian, TXRegistration pendingN669HV2plus 1 LLC · Homer, AKN66HJEcho Foxtrot Holdings LLC · Lewes, DEN674THTimberline Helicopters Inc · Sandpoint, IDN679HHillcrest Aircraft Co · Lewiston, IDN67FURotak LLC · Anchorage, AKN6828Northwest Helicopters LLC · Olympia, WAN68ECCopter Lease LLC Trustee · Albuquerque, NMN7042LSouthwest Florida Aviation · Arcadia, FLN7042NAgriforrestal Applications Inc · Arcadia, FLN710WDA&P Helicopters Inc · Richvale, CAN714MQHaus Michael D · Concord, CAN730VBAsa Security LLC · Anchorage, AKN737HFSpitfire Ventures LLC · San Antonio, TXN750HPRegistration Pending · Knoxville, TNRegistration pendingN75462Brown Helicopter Inc · Pensacola, FLN771ARVertical Access Corp · Lewes, DEN775BBCopter Lease LLC Trustee · Albuquerque, NMN806SBScotts Helicopter Service · Le Sueur, MNN82276Air Cav Helicopters LLC · Wilmington, DEN826HFArmy Aviation Hertiage Foundation And Museum · Hampton, GAN839PFRice Aircraft Services Inc · Olivehurst, CAN841MRock Creek Leasing LLC · Sapulpa, OKN849DBD & B Aviation Brokerage Services LLC · Wilmington, DEN850MJones Aviation · Biggs, CAN87LHHill Lawrence E · Marion, MTN88976R Consulting & Sales Inc · Carson City, NVN88992Premier Aircraft Services LLC · Bakersfield, CAN893PMPorter Flying Service · Durham, CAN911RQSimmons Robert J · Hayward, CAN91320Avag Inc · Richvale, CAN92530S W Florida Aviation International Inc · Arcadia, FLFirst renewal noticeN933CHCoastal Helicopters LLC · La Verne, CAN94NWNorthwest Helicopters I Inc · Olympia, WAN96ECAv8-Orr Helicopter Services Inc · Hamilton, MTN97NWNorthwest Helicopters LLC · Olympia, WAN98NWPope James D · Clarkston, WAN99021Magnum Aviation LLC · Goff, KS
Back to AD 2002-03-01