AD 74-22-07
Registered aircraft · 95
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:74-22-07')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:74-22-07')
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:74-22-07') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:74-22-07') 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.
N474THTop Hand Inc · Laurel, MTN5073XMartins Dusters Inc · Colusa, CAN51AFEastern Stearman Inc Trustee · Leesburg, VAN526MWMountain West Helicopters LLC · Saratoga Springs, UTN540FUAdf Helicopters Inc · Brewster, WAN574PDRegistration Pending · Arbuckle, CARegistration pendingN58468Long-Line Leasing LLC · Saratoga Springs, UTN599HFNext Level Marine LLC · Mount Pleasant, TXN59HPHansen Albert C · Mojave, CAN606HFAgriforrestal Applications Inc · Cape Coral, FLN61650Great Falls Property LLC · Auburn, MEN6180AJones Aviation Inc · Biggs, CAN6257PPremier Aircraft Services LLC · Bakersfield, CAN62767Aquila Helicopters LLC · Elliston, MTN638HAHelicopter Applicators Inc · Gettysburg, PAN64770Premier Aircraft Services LLC · Bakersfield, CAN661UHRegistration Pending · Midlothian, TXRegistration pendingN669HV2plus 1 LLC · Homer, AKN66HJEcho Foxtrot Holdings LLC · Lewes, DEN6828Northwest Helicopters LLC · Olympia, WAN7042LSouthwest Florida Aviation · Arcadia, FLN7042NAgriforrestal Applications Inc · Arcadia, FLN710WDA&P Helicopters Inc · Richvale, CAN714MQHaus Michael D · Concord, CAN737HFSpitfire Ventures LLC · San Antonio, TXN750HPRegistration Pending · Knoxville, TNRegistration pendingN75462Brown Helicopter Inc · Pensacola, FLN771ARVertical Access Corp · Lewes, DEN806SBScotts Helicopter Service · Le Sueur, MNN82276Air Cav Helicopters LLC · Wilmington, DEN826HFArmy Aviation Hertiage Foundation And Museum · Hampton, GAN841MRock Creek Leasing LLC · Sapulpa, OKN88976R 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 noticeN94NWNorthwest Helicopters I Inc · Olympia, WAN96ECAv8-Orr Helicopter Services Inc · Hamilton, MTN97NWNorthwest Helicopters LLC · Olympia, WAN98NWPope James D · Clarkston, WAN99021Magnum Aviation LLC · Goff, KSN99478Vf99478 LLC · Wilmington, DEN99675Alaska Remote Outfitters LLC · Kenai, AK
Back to AD 74-22-07