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.
N785CBAdvanced Aerial Services Inc · Bristol, VAN78906King County Sheriffs Office · Seattle, WAN789SJAgricultural Air Services LLC · Jupiter, FLN78AMBell206 LLC · Anchorage, AKN78BRMontana Air Tankers LLC · Three Forks, MTN78MEElliott Enterprises Group LLC · Wilmington, DEN78NLH&G Farms Inc · Corcoran, CAN7935JAerospace Trust Management LLC Trustee · Wilmington, DEN7963JSan Juan Aviation LLC · Wilmington, DEN79987Usda Aphis Ws · Cedar City, UTN800JBHelicopter Applicators LLC · Pembroke, NHN801JBNewwest LLC · Pembroke, NHN803JBGuardian Aero LLC · Flora, ILN804LASouthern Helicopter Inc · O Brien, FLN806LACoastal Helicopters Inc · Panama City, FLN808QPalmer Carroll W · Harper, ORN812URRotor Concepts LLC · Lakeside, AZN813RRIndian River County Sheriffs Office · Vero Beach, FLN81519Bell Textron Inc · Fort Worth, TXN8155JAircraft Trustee Services Inc Trustee · Dover, DEN8159JForming Agrotors Inc · Louisville, MSN818HHHermanns Helicopters LLC · Arlington, WAN818RLDoor To Door Aviation LLC · Wilmington, DEN81ALOrgis B J · Hallettsville, TXN81PHProvine Helicopter Service Inc · Greenwood, MSN820HRoma Air Corp · Belle Glade, FLN821CAChem-Air LLC · Shreveport, LAN827WAWarner Alan/Whiskey Alpha LLC · Fort Worth, TXN828HAHelo N828ha LLC · Richmond, VAN83149Sky Air Center Unlimited LLC · Burleson, TXN83193R&B Helicopters Inc · Salinas, CAN831RLOrgis B J · Hallettsville, TXN833AMBryant William D · Woodlawn, VAN837YMHeli Mart Inc · Costa Mesa, CAN83APL&R Investment Partners LLC · Wilmington, DEN83CKGeorgia Equipment And Suplus Inc · Peachtree City, GAN83TJGotcher Corby W · West Columbia, TXN841YTTrue Drilling LLC · Casper, WYN84CKCroman Corp · White City, ORN85CAChurchill Scott · Le Sueur, MNN85RBScott John D · Lyndon, KSN860DPNewton Property Leasing LLC · Greene, IAN862MChorman Spraying LLC · Milton, DEN866ELEly Ag Services LLC · Sallisaw, OKN866HLake Superior Helicopters LLC · Duluth, MNN866MMiddlesex County Mosquito Extermination Commission · Edison, NJN867CHNorthview Christian Church · Dothan, ALN868JBHorizon Helicopter LLC · Pembroke, NHN868KKCoastal Helicopters Inc · Panama City, FLN86DXTopside Aviation Inc · Brasstown, NC
Back to AD 89-10-11 R1