AD 2005-10-13
Registered aircraft · 1,224
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:2005-10-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2005-10-13')
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:2005-10-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2005-10-13') 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.
N818HHHermanns Helicopters LLC · Arlington, WAN818RLDoor To Door Aviation LLC · Wilmington, DEN8199JPeace And Freedom Helicopters LLC · Wilmington, DEN81ALOrgis B J · Hallettsville, TXN81PHProvine Helicopter Service Inc · Greenwood, MSN81WHWarbirds-3 LLC · Kalispell, MTN820HRoma Air Corp · Belle Glade, FLN822JCAirtrade Aviation Corp · Lewes, DEN822LJCaribe Helicopters Inc · Coral Gables, FLN827WAWarner Alan/Whiskey Alpha LLC · Fort Worth, TXN82855Triple F Flying Inc · Benton, PAN828HAHelo N828ha LLC · Richmond, VAN828HKHawkeye Helicopter LLC · Lyndon, KSN82FHelicopters Inc · Cahokia, ILN83149Sky Air Center Unlimited LLC · Burleson, TXN831RLOrgis B J · Hallettsville, TXN8330PN24wd Capital Holdings LLC · Redding, CAN833AMBryant William D · Woodlawn, VAN8353FRoyal Helicopter Services LLC · Exeter, CAN8371FBank Of Utah Trustee · Salt Lake City, UTN8372FCity Of Houston Police Department · Houston, TXN8373FI T A Services LLC · Westminster, MDN83APL&R Investment Partners LLC · Wilmington, DEN83CKGeorgia Equipment And Suplus Inc · Peachtree City, GAN83TJGotcher Corby W · West Columbia, TXN842JHJack Harter Helicopters Inc · Lihue, HIN844ADOcean Air Helicopter Inc · Valley Center, CAN845BHBering Air Inc · Nome, AKN8465EEnglish Air Service LLC · Georgetown, TXN84CKCroman Corp · White City, ORN85CAChurchill Scott · Le Sueur, MNN85RBScott John D · Lyndon, KSN860DPNewton Property Leasing LLC · Greene, IAN861MCQuicksilver Air Inc · Fairbanks, AKN8628XRegistered aircraftN862MChorman Spraying LLC · Milton, DEN863MCQuicksilver Air Inc · Fairbanks, AKN8648BRegistered aircraftN8648FVertol Systems Co Inc · Destin, FLN8652QEnstrom Helicopter Corp · Menominee, MIN865HSRoyal Helicopter Services LLC · Exeter, CAN866ELEly Ag Services LLC · Sallisaw, OKN866MMiddlesex County Mosquito Extermination Commission · Edison, NJN868HWeyerhaeuser Nr Co · Seattle, WAN868JBHorizon Helicopter LLC · Pembroke, NHN868KKCoastal Helicopters Inc · Panama City, FLN868WDah Aircraft LLC · Georgetown, SCN869VSVertol Systems Co Inc · Destin, FLN86DXTopside Aviation Inc · Brasstown, NCN86FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FL
Back to AD 2005-10-13