AD 97-07-05
Registered aircraft · 187
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:97-07-05')
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-07-05')
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-07-05') 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-07-05') 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.
N714MQHaus Michael D · Concord, CAN7239LWallasch Charles Trustee · Alpine, WYN7239TOlympic Jet Inc · Olympia, WAN730VBAsa Security LLC · Anchorage, AKN737HFSpitfire Ventures LLC · San Antonio, TXN750HPRegistration Pending · Knoxville, TNRegistration pendingN75462Brown Helicopter Inc · Pensacola, FLN767NADh Helicopter Inc · Whitefield, MEN771ARVertical Access Corp · Lewes, DEN775BBCopter Lease LLC Trustee · Albuquerque, NMN777GHRugged Flightworks LLC · Big Piney, WYN806SBScotts Helicopter Service · Le Sueur, MNN82276Air Cav Helicopters LLC · Wilmington, DEN826HFArmy Aviation Hertiage Foundation And Museum · Hampton, GAN832DHSkyhop LLC · Santa Rosa, CAN839PFRice 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, WAN959BHBering Air Inc · Nome, AKN96ECAv8-Orr Helicopter Services Inc · Hamilton, MTN970MBSky High Leasing LLC · Montrose, CON97NWNorthwest Helicopters LLC · Olympia, WAN98NWPope James D · Clarkston, WAN99021Magnum Aviation LLC · Goff, KSN99478Vf99478 LLC · Wilmington, DEN99675Alaska Remote Outfitters LLC · Kenai, AKN99WLCorpat Inc · Missoula, MT
Back to AD 97-07-05