AD 73-05-01
Registered aircraft · 119
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:73-05-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:73-05-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:73-05-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:73-05-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.
N102BBNester Randal K · Seguin, TXN1139WMundis Jay E · Red Lion, PAN1150WBoho LLC · Lewes, DEN115SLDykstra Donald J · Dorr, MIN1184WJohnson Kyle L · Exira, IAN119NRSlikker Flying Service Inc · Buttonwillow, CAN12RNSunshine Holding LLC · Danbury, CTN12UHJstream Lc · Sheridan, WYN130HAC&C Helicopters Inc · Kuna, IDN132HASky Copters Inc · Westmoreland, KSN133HAHanson Leasing Inc · Bad Axe, MIN1342XHhi Farms LLC · Hamilton, MIN1396XHammock Flying Service Inc · Smithville, ARN139HAKnutson Flying Service Inc · Tioga, NDN1420WHammock Flying Service Inc · Smithville, ARN14637Fort Wolters Helicopter Inc · Mineral Wells, TXN14EFInternational Air Services Inc Trustee · Carson City, NVN14MQFort W0lters Helicopter Inc · Mineral Wells, TXN1512EFort Wolters Helicopters · Mineral Wells, TXN1523TBartlett Robert E · Cleveland, TXN152DBDurango LLC · Brownsville, TXN16NRParagon Helicopter Services LLC · Claremore, OKN180HAAmbrosini Helicopters Inc · Fresno, CAN191SGAngel William D · Rancho Cucamonga, CAN196FTContinental Title Trust LLC Trustee · Wichita, KSN2098Classic Rotors Museum · Ramona, CAN21MPBack Jeff · Oneonta, NYN22353Rye Corp LLC · Lenoir City, TNN2275MBorszich Claude C Jr · Phoenix, AZN22SPParagon Helicopter Services LLC · Claremore, OKN236HAEndries Ryan A · Milwaukee, WIN238NRegistration Pending · Canton, GARegistration pendingN25196Fort Wolters Helicopter Inc · Mineral Wells, TXN255PHEgenolf Evan Patrick · Laramie, WYN2678YNorthwest Helicopters I Inc · Olympia, WAN285TTValiair Lc Trustee · Casper, WYN2VUUpham Slade C · Fort Worth, TXN305ALForney Museum Of Transportation · Denver, CON3068GWheatley Lester E Jr · Riverside, CAN3081GScotts Helicopter Service Inc · Le Sueur, MNN333TVChap Jerry L · Patagonia, AZN3351FCarey James D · Winterset, IAN34SDFort Wolters Helicopters Inc · Mineral Wells, TXN36670S & S Landscape Supply Inc · Grand Junction, CON38092Hhi Farms LLC · Hamilton, MIN40277Northwest Helicopters I Inc · Olympia, WAN4029SSlikker Flying Service Inc · Buttonwillow, CAN40346Rutland Flying Service · Ridge Spring, SCN4070BWheatley Lester E Jr · Priest River, IDN410NRHaynes Cory W · Heyburn, ID
Back to AD 73-05-01