AD 89-10-11 R1
Registered aircraft · 855
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:89-10-11-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:89-10-11-R1')
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:89-10-11-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:89-10-11-R1') 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.
N411NCColumbus Helicopters LLC · Columbus, INN411TDRotor Head Helicopters LLC · Torrance, CAN4155KPereira Alfred R Jr · Valley Springs, CAN418SVCanyon Creek Investments Llp · Sapulpa, OKN41EWMemphis Police Department · Memphis, TNN41PHTobler Hans P · Anchorage, AKN41SJMti Travel Inc · Fountain Hills, AZN422RHJames V Paige Jr Development Corp · Bemus Point, NYN422SDParker Helicopter LLC · Watsonville, CAN4237MTrideca Vertical Solutions LLC · Dallas, TXN429CEDelcamp Michael · Richmond, TXN43142Scotts Helicopter Services Inc · Le Sueur, MNN431CAChem-Air LLC · Shreveport, LAN4328Aircraft Guaranty Corp Trustee · Oklahoma City, OKN432TVSky Choppers LLC · Seneca, KSN433HAHelo N433ha LLC · Richmond, VAN43681World Trade Enterprises LLC · Lucas, TXN43HHJohnson Flying Service LLC · Exira, IAN4445HBell Textron Inc · Fort Worth, TXN444TVScotts Helicopter Service Inc · Le Sueur, MNN4452Bravo Aviation LLC · Chicago, ILN448EAEdgefield Aviation LLC · Sandy, ORN449SS & L Farm And Ranch LLC · Georgetown, TXN44BCRiggs Rock A · Lake Mary, FLN452MCCitrus County Mosquito Control District · Lecanto, FLN453RARanger Aviation Leasing LLC · Wilmington, DEN454MSCb Couch Inc · Walcott, ARN455TVCox Paul G DBA · Bryce, UTN4569U S Army · Ft Rucker, ALN463RARanger Aviation Leasing LLC · Wilmington, DEN472MRight Brother Aviation LLC · Chaffee, NYN476KAN476ka LLC · Wasilla, AKN47HHJkt LLC · Douglas, WYN483RVan Horn Aviation LLC · Tempe, AZN48552Brown Helicopter Inc · Pensacola, FLN488BCButte County Sheriffs Office · Oroville, CAN48HHVarney Aviation LLC · Bangor, MEN490WMSouth Florida Water Management District · West Palm Beach, FLN49589North Wind Aviation LLC · Chelan, WAN49651Withrotor Aviation Inc · Lakeview, ORN49660Provell Chris J · Rio Linda, CAN499WMAgricultural Air Services LLC · Jupiter, FLN49TVHawke Aircraft Holdings Inc · Sandpoint, IDN5001KMontana Air Tankers LLC · Three Forks, MTN5005NAircoastal Helicopters Inc · Lantana, FLN5008KL&R Investment Partners LLC · Wilmington, DEN500NRAycd LLC · Allentown, PAN500USYarak Aviation LLC · Big Timber, MTN5010KHayward Enterprises Inc · High Point, NCN5010PMarkov Michael J · Oceanside, CA
Back to AD 89-10-11 R1