AD 75-01-05
Registered aircraft · 108
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:75-01-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:75-01-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:75-01-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:75-01-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.
N40722West Valley Aviation Inc · Five Points, CAN41109Lrh Equipment LLC · Pendleton, ORN4376DPlanes Of Fame Air Museum · Chino, CAN43FKKaman Aerospace Corp · Bloomfield, CTN444SJJones Flying Service · Biggs, CAN453CCHelo 1 LLC · Anchorage, AKN474THTop 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, 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, DEN6828Northwest Helicopters LLC · Olympia, WAN7042LSouthwest 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, DEN806SBScotts 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, CA
Back to AD 75-01-05